Transfer Delay (Critical Care): Difference between revisions
Ttenbergen (talk | contribs) m →Admit DtTm or Dispo DtTm < 2020-10-01 00:00: readability |
Ttenbergen (talk | contribs) m →Admit DtTm or Dispo DtTm < 2020-10-01 00:00: readability fix 2 |
||
| Line 44: | Line 44: | ||
UPDATE L_Log INNER JOIN created_Program ON L_Log.D_ID = created_Program.D_ID SET L_Log.Transfer_Ready_DtTm = [transfer_ready_dttm]+IIf(TimeValue([dispo_dttm])<#12/30/1899 10:0:0#,#12/30/1899 0:1:0#,#12/30/1899 10:0:0#) | UPDATE L_Log INNER JOIN created_Program ON L_Log.D_ID = created_Program.D_ID SET L_Log.Transfer_Ready_DtTm = [transfer_ready_dttm]+IIf(TimeValue([dispo_dttm])<#12/30/1899 10:0:0#,#12/30/1899 0:1:0#,#12/30/1899 10:0:0#) | ||
WHERE ((L_Log.Transfer_Ready_DtTm>#1/1/1900#) | WHERE ((L_Log.Transfer_Ready_DtTm>#1/1/1900#) | ||
AND ((created_Program.program)="cc") | |||
AND ((L_Log.Dispo_DtTm) Is Not Null) | |||
AND ((TimeValue(Nz([transfer_ready_dttm],#1/1/1900#))=#12/30/1899#)=True) | |||
AND ((DateValue(Nz([dispo_dttm],#1/2/1900#))=DateValue(Nz([transfer_ready_dttm],#1/1/1900#)))=True)); | |||
=== [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === | === [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === | ||