Date and Time Format: Difference between revisions

(2 intermediate revisions by the same user not shown)

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.

* 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~~

== Date Format in CCMDB.accdb, front-end and other .mdbs ==

* 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?)~~

* most places use yyyy-mm-dd, occasionally yy-mm-dd for short range dates;

* ~~yymonthdd~~ HH:mm ~~on patient list~~.

* [[Patient List]] uses yymmmdd HH:mm (ie spelled out month) for easier visual but longer field

* A 24-hr clock is used.

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

== in file formats and other sortable lists ==

** {{discussion}} this is the ISO standard, could we change all to that?

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

[[Category:Standards and Conventions]]

[[Category:Registry Data]]

[[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.
-* 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
+== Date Format in CCMDB.accdb, front-end and other .mdbs ==
-* 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?)
+* most places use yyyy-mm-dd, occasionally yy-mm-dd for short range dates;
-* yymonthdd HH:mm on patient list.
+* [[Patient List]] uses yymmmdd HH:mm (ie spelled out month) for easier visual but longer field
+* A 24-hr clock is used.
-* yyyy-mm-dd HH:mm (eg. 2016-04-25 17:03) is used in [[Category:2016 Time and Place changes]]
+== in file formats and other sortable lists ==
-** {{discussion}} this is the ISO standard, could we change all to that?
+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]]