Created AdmitDtTm query: Difference between revisions

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]] 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]))
That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest [[Service tmp entry]] DtTm for the profile.


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