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) mNo edit summary |
||
| 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 == | |||
* 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}} | |||
[[Category: Standards and Conventions]] | |||
[[Category: Registry Data]] | |||
[[Category: Data Collection Guide]] | [[Category: Data Collection Guide]] | ||
Latest revision as of 11:44, 2020 December 23
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: |