Transfer Delay (Critical Care): Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 38: | Line 38: | ||
Not tested yet, but the code to update this would be something like | Not tested yet, but the code to update this would be something like | ||
:: Update L_Log | :: Update L_Log | ||
:: | :: SET L_Log.Transfer_Ready_DtTm = [Transfer_Ready_DtTm]+IIf(TimeValue([Dispo_DtTm])<#12/30/1899 10:0:0#,#12/30/1899 12:1:0#,#12/30/1899 10:0:0#) | ||
:: | :: WHERE (((TimeValue(Nz([Transfer_Ready_DtTm],#12/30/1899 0:1:0#)))=#12/30/1899#)); | ||
=== [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === | === [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === | ||