Transfer Ready DtTm field: Difference between revisions
Ttenbergen (talk | contribs) m moved "status changing back and forth" to Transfer Ready DtTm tmp entry |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
See [[Transfer Ready DtTm tmp entry]] | See [[Transfer Ready DtTm tmp entry]] | ||
{{Todo | |||
| who = Tina | |||
| question = | |||
Once the following query comes up empty this field should be removed from view in [[CCMDB.accdb]] | |||
<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 | |||
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_action = 2021-05-14 | |||
}} | |||
{{Data_element | {{Data_element | ||