Custom date and time format strings
Custom date and time format strings format dates in Date/Time fields.
Format: Specify the desired format for this field. A valid format is composed of the following pattern letters.
All lower case and upper case characters not mentioned in the table below are reserved.
| Format Representation | Description |
|---|---|
| %a | Abbreviated weekday name |
| %A | Full weekday name |
| %b | Abbreviated month name |
| %B | Full month name |
| %C | Century number |
| %d | The day of the month (00 – 31) |
| %e | The day of the month (0 – 31) |
| %H | Hour (00 – 23) |
| %I | Hour (01 – 12) |
| %j | Day of the year (000 – 366) |
| %k | Hour (0 – 23) |
| %l | hour (1 – 12) |
| %m | month (01 – 12) |
| %M | minute (00 – 59) |
| %n | a newline character |
| %p | “PM” or “AM” |
| %P | “pm” or “am” |
| %S | second (00 – 59) |
| %s | number of seconds since Epoch (since Jan 01 1970 00:00:00 UTC) |
| %t | a tab character |
| %U, %W, %V | the week number |
| %u | the day of the week (1 – 7, 1 = SUN) |
| %y | year without the century (00 – 99) |
| %Y | year including the century (for example 1979) |
| %% | a literal % character |