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
  • Admit_DtTm: CDate(Nz([Service_DtTm],Nz([Accept_dttm],Nz([Arrive_Dttm],#2300-01-01#))))