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]] 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.  
 
 
{{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 ]].
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 ==  
{{Related Articles}}
{{Related Articles}}


[[Category: Data structure]]
[[Category:Data structure]]
[[Category:Created Variables]]

Revision as of 17:56, 29 December 2021

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.


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 .

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Related articles

Related articles: