Date and Time Format: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(12 intermediate revisions by 2 users not shown)
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, i.e. 00:01 – 23:59
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.  
** (resolve from discussion)


{{discussion}}
== Date Format on the PCs ==
==Discussion==
This is unpredictable as eHealth can mess with centrally. Often it is mm-dd-yyyy with a 12-hr clock.
* I pulled this out of admit/discharge time because at least the data part also applies to DOB, and all of it also applies to tmp collections. Except maybe the midnight rule, but that's the next comment. [[User:Ttenbergen|Ttenbergen]] 09:37, 11 February 2009 (CST)


* when I grabbed this from admit and discharge, it had "0000 & 2400 is not acceptable". In the admit/discharge article it refers to using 23:59 for midnight exactly. Are there other places where that should be used? If not, then the midnight rule should be added here and removed from the admit/discharge. [[User:Ttenbergen|Ttenbergen]] 09:37, 11 February 2009 (CST)
== Related articles ==
{{Related Articles}}


[[Category: Data Collection Guide]]
[[Category:Standards and Conventions]]
[[Category:Questions General Collection]]
[[Category:Registry Data]]
 
 
 
[[Category:Data Collection Guide]]

Latest revision as of 10:32, 30 July 2025

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Date_and_Time_Format&oldid=166016"