Created AdmitDtTm query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The query | 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 . |
|
