Separation of date and time fields: Difference between revisions

 
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