sLongDate, sShortDate, and sTimeFormat will all recognize any combination of the following values, all of which are case-sensitive.
All strings should be surrounded by single quotes, and any single quotes should be entered as four single quotes in a row:
| Value | Example |
|---|---|
| it''''s | it's |
| 'Today is 'M/dd/yy' and it''''s 'h:mm | Today is 01/22/99 and it's 8:18 |
The day can be displayed in one of four formats using a lowercase "d".
| Value | Meaning | Example |
|---|---|---|
| d | Day of the month as digits without leading zeros for single digit days. | 5 |
| dd | Day of the month as digits with leading zeros for single digit days. | 05 |
| ddd | Day of the week as a three letter abbreviation. | Mon |
| dddd | Day of the week as its full name. | Monday |
The month can be displayed in one of four formats using capital "M". The letter "M" must be uppercase to distinguish months from minutes.
| Value | Meaning | Example |
|---|---|---|
| M | Month as digits without leading zeros for single digit months. | 1 |
| MM | Month as digits with leading zeros for single digit months. | 01 |
| MMM | Month as a three letter abbreviation. | Jan |
| MMMM | Month as its full name. | January |
The year can be displayed in one of three formats using lowercase "y".
| Value | Meaning | Example |
|---|---|---|
| y | Year represented only by the last digit, if the year is less than 10. Years greater than 10 will be given the value of yy. | 9 |
| yy | Year represented only by the last two digits. | 09 |
| yyyy | Year represented by the full 4 digits. | 1909 |
The period/era string can be displayed in a single format using the letter "g". The letter "g" must be lowercase. If you include the gg in a date string that does not have any associated Era string, the gg will be ignored.
| Value | Meaning |
|---|---|
| (Null) | Gregorian dates are used. Does nothing if Gregorian is value of iCalendarType |
| gg | Period/era string. This is used by Windows to calculate the year when an optional calendar is selected. See iCalendarType for optional Calendars. |
The time can be displayed in one of many formats using the letter "h" or "H" to denote hours, the letter "m" to denote minutes, the letter "s" to denote seconds and the letter "t" to denote the time marker. The lowercase "h" denotes the 12 hour clock and uppercase "H" denotes the 24 hour clock. The "m" must be lowercase to denote minutes as opposed to Months. The "s" for seconds and "t" for the time marker string must also be lowercase.
| Value | Meaning | Example |
|---|---|---|
| h | Hours without leading zeros for single digit hours (12 hour clock). | 1 |
| hh | Hours with leading zeros for single digit hours (12 hour clock). | 01 |
| H | Hours without leading zeros for single digit hours (24 hour clock). | 1 |
| HH | Hours with leading zeros for single digit hours (24 hour clock). | 01 |
| m | Minutes without leading zeros for single digit minutes. | 9 |
| mm | Minutes with leading zeros for single digit minutes. | 09 |
| s | Seconds without leading zeros for single digit seconds. | 5 |
| ss | Seconds with leading zeros for single digit seconds. | 05 |
| t | One character time marker string. This will be the first letter of the values in the AM symbol or PM symbol boxes in Regional Options as determined by the vales of s1159 or s2359. | A |
| tt | Multi-character time marker string. This will be values in the AM symbol or PM symbol boxes in Regional Options as determined by the vales of s1159 or s2359. | AM |