Lab identification in the DSM data: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 13: | Line 13: | ||
* <code>" WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code> | * <code>" WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code> | ||
** ie we start the range with the [[Arrive_DtTm]], not the [[Accept_DtTm]] | ** ie we start the range with the [[Arrive_DtTm]], not the [[Accept_DtTm]] | ||
{{Discuss | | {{Discuss |We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far? }} | ||
=== counts === | === counts === | ||