Date and Time Format: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The date and time formats for | The Critical Care and Medicine Database uses different date and time formats throughout as work best for their context. The dates are stored internally in a format-independent way, so we can change this to suit us. | ||
* | == Date Format in CCMDB.accdb, front-end and other .mdbs == | ||
* | * most places use yyyy-mm-dd, occasionally yy-mm-dd for short range dates; | ||
* [[Patient List]] uses yymmmdd HH:mm (ie spelled out month) for easier visual but longer field | |||
* A 24-hr clock is used. | |||
== in file formats and other sortable lists == | |||
In sortable lists attempt to use yyyy-mm-dd (numerical month) with a 24-hr clock because it will sort right. Same applies for file names. | |||
== Date Format on the PCs == | |||
This is unpredictable as eHealth can mess with centrally. Often it is mm-dd-yyyy with a 12-hr clock. | |||
[[Category: Data Collection Guide]] | == Related articles == | ||
{{Related Articles}} | |||
[[Category:Standards and Conventions]] | |||
[[Category:Registry Data]] | |||
[[Category:Data Collection Guide]] | |||
Latest revision as of 10:32, 30 July 2025
The Critical Care and Medicine Database uses different date and time formats throughout as work best for their context. The dates are stored internally in a format-independent way, so we can change this to suit us.
Date Format in CCMDB.accdb, front-end and other .mdbs
- most places use yyyy-mm-dd, occasionally yy-mm-dd for short range dates;
- Patient List uses yymmmdd HH:mm (ie spelled out month) for easier visual but longer field
- A 24-hr clock is used.
in file formats and other sortable lists
In sortable lists attempt to use yyyy-mm-dd (numerical month) with a 24-hr clock because it will sort right. Same applies for file names.
Date Format on the PCs
This is unpredictable as eHealth can mess with centrally. Often it is mm-dd-yyyy with a 12-hr clock.
Related articles
| Related articles: |