What is the syntax for TimSt?
TimeSt(datetime, format, ExtendedYears)
- datetime = a date/time serial number
- 0 = 01 Jan 1960
- 2936549 = 31 Dec 9999
* Note the ExtendedYears field if you want to return a date past 31 Dec 2059
- format = A string that formats the result of the function. All the characters in the format argument appear in the result, except for the following characters, which return date/time component values:
- y (two digits of the year e.g. 21)
- Y (four digits of the year e.g. 2021)
- m (two digits of the month e.g. 01 to 12)
- M (first three characters of the month e.g. JAN, FEB)
- d (two digits of the day e.g. 01 to 31)
- D (digit of the day e.g. 1 to 31)
- h (hour in military time e.g. 00 to 23)
- H (standard hour e.g. 1 to 12)
- i (minute e.g. 00 to 59)
- s (second e.g. 00 to 59)
- p (a.m. or p.m.)
- ExtendedYears = OPTIONAL Boolean parameter on the date range recognised (if this field is empty, 0 is used)
- 0 = returns a date falling between 01 Jan 1960 to 31 Dec 2059
- 1 = returns a date falling between 01 Jan 1960 to 31 Dec 9999
