Created AdmitDtTm query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The query | {{DISPLAYTITLE:created_AdmitDtTm query}} | ||
The '''created_AdmitDtTm query''' in [[CCMDB.accdb]], [[CFE]] and [[DSM Labs Consistency check.accdb]] contains the "admit date and time" of a profile according to the different definitions used over time. | |||
== Log == | |||
* 2023-01-12 | |||
** updated so query doesn't crash if all 3 dates are null and instead provides a date of 2300-01-01 | |||
** <code>Admit_DtTm: CDate(Nz([Service_DtTm],Nz([Accept_dttm],Nz([Arrive_Dttm],#2300-01-01#))))</code> | |||
== Related articles == | == Related articles == | ||
Latest revision as of 10:33, 28 January 2025
The created_AdmitDtTm query in CCMDB.accdb, CFE and DSM Labs Consistency check.accdb contains the "admit date and time" of a profile according to the different definitions used over time.
Log
- 2023-01-12
- updated so query doesn't crash if all 3 dates are null and instead provides a date of 2300-01-01
Admit_DtTm: CDate(Nz([Service_DtTm],Nz([Accept_dttm],Nz([Arrive_Dttm],#2300-01-01#))))