Date and Time Format: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| Line 15: | Line 15: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Standards and Conventions]] | [[Category:Standards and Conventions]] | ||
[[Category: Registry Data]] | [[Category:Registry Data]] | ||
[[Category: Data Collection Guide]] | [[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: |