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 AdmitDtTm 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.  
The query created AdmitDtTm 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([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where Service_DtTm is from [[created_FirstService query]]
{{TT | needs fixing:
 
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 ]].
}}


== Related articles ==  
== Related articles ==  

Revision as of 10:27, 30 December 2021