Created AdmitDtTm query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
The query created_FirstService in [[CFE]] contains the "admit date and time" of a profile according to the different definitions used over time.  
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.  


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 ]].
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 ]].

Revision as of 16:07, 15 September 2021