Date and Time Format: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-The date and time formats for the Critical Care and Medicine Databasea are:
+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.
-* '''month / day / year'''
+== Date Format in CCMDB.accdb, front-end and other .mdbs ==
-**Please be extra careful not to transpose month and day
+* 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.
-* '''HH:mm'''
+== in file formats and other sortable lists ==
-** on the 24 hour clock, use i.e. 00:01 – 23:59. Do not use 24:00 hrs
+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.
-**for midnight use 23:59
+== 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 ==
-[[Category:Questions General Collection]]
+{{Related Articles}}
+[[Category:Standards and Conventions]]
+[[Category:Registry Data]]
+[[Category:Data Collection Guide]]