Formatting exact dates
You must specify exact dates in one of these formats:
-
DYYYYMMDDhhmmss
-
DYYYYMMDD
-
Dhhmmss
| YYYY | This is the four digit year. |
| MM | This is the two digit month, where 01=Jan, 02= Feb, etc. |
| DD | This is the two digit day of the month. |
| hh | This is the two digit hour of the day. |
| mm | This is the two digit minute of the hour. |
| ss | This is the two digit second of the minute. |
Examples
DYYYYMMDDhhmmss - 20080715120130 for 12:01:30 p.m. July 15, 2008
DYYYYMMDD - 20080715 for the start of the day on July 15, 2008
Dhhmmss - 120130 for a time value of 12 hours 1 minute and 30 seconds.