Separation of date and time fields: Difference between revisions
Ttenbergen (talk | contribs) Created page with "This page explains why we encode date and time in separate fields for some values. == Reasons == * our legacy PDA data collection tool implemented date and time as two separate fields * there are more convenient user interface elements in MS Access to enter the two separately * they can easily be combined during analysis == values affected == * L_Log.Start Date field / Start Date field / Start Date and Time * L TmpV2.obsdate and obstime * L Tmp..." |
Ttenbergen (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
== Reasons == | == Reasons == | ||
* our legacy PDA data collection tool implemented date and time as two separate fields | * our legacy PDA data collection tool implemented date and time as two separate fields | ||
* there are more convenient user interface elements in MS Access to enter the two separately | * there are more convenient user interface elements in MS Access to enter the two separately (DatePicker tool / calendar) | ||
* they can easily be combined during analysis | * they can easily be combined during analysis | ||
| Line 11: | Line 11: | ||
* [[L TmpV2]].date_var and time_var | * [[L TmpV2]].date_var and time_var | ||
* original [[Admit date and time]] | * original [[Admit date and time]] | ||
* original [[Transfer Ready date and time]] | |||
* original [[Discharge date and time]] | |||
[[Category:Data structure]] | [[Category:Data structure]] | ||