Separation of date and time fields

From CCMDB Wiki
Revision as of 22:55, 23 October 2025 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Separation_of_date_and_time_fields&oldid=167833"