datetype

DateType

DateType is a relatively recent addition to ACEDB, joining the existing basic types Int, Float and Text. The purpose of a DateType field is to contain a date or time entry in a standardized format.

DateType is flexible in that it will accept partial information as long as it is consistent with the rules. In general, starting with the year, you can add additional data representing month, day, hour, minute and seconds. Dashes, underscores and colons delimit the units. Impossible times are rejected.

DateType can be queried with ">" (greater than> and "<" (less than) understood chronologically.

Legal:

 1997-07-14_13:02:19
 97-07-14_13:02:19
 1997-07-14_13:02
 1997-07-14_13
 1997-07-14
 1997-07
 1997
 now
 today

"now" will be replaced by the current system date and time, e.g. 1997-07-14_13:02:19.
"today" will be replaced by the current system date, e.g. 1997-07-14.
97-07-14_13:02:19 will be converted to 1997-07-14_13:02:19.

Illegal:

 1997-52
 1997-07-
 13:02
 1997-07-14_13:02:19.221