Date and Time Format
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: |