Transfer Ready DtTm field: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 6: | Line 6: | ||
Once the following query comes up empty this field should be removed from view in [[CCMDB.accdb]] | Once the following query comes up empty this field should be removed from view in [[CCMDB.accdb]] | ||
<code> | <code> | ||
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020# AS acc | |||
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020# AS acc | FROM L_Log | ||
WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); </code> | |||
FROM L_Log | |||
WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); | |||
</code> | |||
| todo_added = 2021-04-14 | | todo_added = 2021-04-14 | ||
| todo_action = 2021-05-14 | | todo_action = 2021-05-14 | ||