Created AdmitDtTm query: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-The query created_FirstService in [[CFE]] and [[DSM Labs Consistency check.accdb]] contains the "admit date and time" of a profile according to the different definitions used over time.
+{{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.
-That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest [[Service tmp entry]] DtTm for the profile as taken from [[Created_FirstService query ]].
+== 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}}
-[[Category: Data structure]]
+[[Category:Data structure]]
+[[Category:Created Variables]]