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.
-* in CCMDB.mdb
+== Date Format in CCMDB.accdb, front-end and other .mdbs ==
-** '''<day number> / <month name> / year'''
+* most places use yyyy-mm-dd, occasionally yy-mm-dd for short range dates;
-** '''HH:mm'''
+* [[Patient List]] uses yymmmdd HH:mm (ie spelled out month) for easier visual but longer field
-*** on the 24 hour clock, use i.e. 00:01 – 23:59. Do not use 24:00 hrs
+* A 24-hr clock is used.
-* not sure what's used in [[TMSX]]
+== 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]]