Date and Time Format: Difference between revisions

Line 1:

The Critical Care and Medicine ~~Databasea~~ 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.

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 ==

[[Category: Standards and Conventions]]

[[Category: Registry Data]]

* yy-mon-dd HH:mm (eg. 16-04-25 17:03) is used sometimes to save space, e.g. admit and discharge display on top of patient viewer

* yyyy-month-dd (1960-Jan-01) is used in some places, eg DOB, tmp date, in Patient viewer (any objections if I make it e.g. 1960-01-01 for consistency?)

* yymonthdd HH:mm on patient list.

* yyyy-mm-dd HH:mm (eg. 2016-04-25 17:03) is used in much of [[:Category:2016 Time and Place changes]]

[[Category: Data Collection Guide]]

@@ Line 1: / Line 1: @@
-The Critical Care and Medicine Databasea 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.
+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]]
-* yy-mon-dd HH:mm (eg. 16-04-25 17:03) is used sometimes to save space, e.g. admit and discharge display on top of patient viewer
-* yyyy-month-dd (1960-Jan-01) is used in some places, eg DOB, tmp date,  in Patient viewer (any objections if I make it e.g. 1960-01-01 for consistency?)
-* yymonthdd HH:mm on patient list.
-* yyyy-mm-dd HH:mm (eg. 2016-04-25 17:03) is used in much of [[:Category:2016 Time and Place changes]]
 [[Category: Data Collection Guide]]