Created AdmitDtTm query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 2: Line 2:


== Log ==
== 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
* 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 ==  

Revision as of 09:32, 17 October 2024

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#))))

Related articles

Related articles: