<< Click to Display Table of Contents >>
Date and Time Format |
The syntax for date and time formats differs a little from spreadsheets, following the mode used by Windows region and language configurations. Dates are numerical values where the integer part represents days since December 31st 1899 and the fractional part represents hours in day fractions.
The minimum year supported is 100 and the maximum is 9999, ensuring a resolution of at least one millisecond in the whole interval. Names of months and week days, default day, month, and year sort order, and the date and time separators are all used according to Windows region and language configurations. The next table contains examples of values formatted using a date and time format.
Date and time formats
Data |
Format |
Formatted Output |
---|---|---|
1234.56789 |
dd/MMMM/yyyy |
18/may/1903 |
0.56789 |
hh:mm:ss.000 tt |
01:37:45.696 PM |
12.345678 |
hh\hmm\mss.000\s |
296h17m46.667s |
NOTE |
Values stored in object properties referring to dates are numerical values, calculated using the previous formula. The Find and Replace tool uses that stored value on the search process, and not the formatted date and time values displayed on the Properties List. |