Date and Time Format: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m no need to change to ISO sometime the odd formats we use work better for us; currently using specifically discussed formats in different places. |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
The Critical Care and Medicine | 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 == | |||
* yyyy- | * 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. | |||
[[Category: Data Collection Guide]] | == 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}} | |||
[[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: |