Transfer Ready DtTm field: Difference between revisions

mNo edit summary
mNo edit summary
Line 10: Line 10:
  WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); </code>
  WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); </code>


* 2022-04-14 checked again, still there; H7_HSC_IICU-3097 was discharged over a year ago, emailed Lisa
* 2022-02-10 checked, one record left and it has dispo dttm H7_HSC_IICU-3097; something seems odd about that one, so look into if still present in a month
* 2022-02-10 checked, one record left and it has dispo dttm H7_HSC_IICU-3097; something seems odd about that one, so look into if still present in a month
| todo_added = 2021-04-14
| todo_added = 2021-04-14