Custom Date Formats
Verb provides preset date formats on collection fields and the ability to create custom date and time formats. To add a custom format, select the 'custom format' option in the list of formats in the field configuration panel.
Date & Time Format Options
| Format Specifier | Description | Examples |
|---|---|---|
d | The day of the month, from 1 through 31. | 2009-06-01T13:45:30 -> 1 2009-06-15T13:45:30 -> 15 |
dd | The day of the month, from 01 through 31. | 2009-06-01T13:45:30 -> 01 2009-06-15T13:45:30 -> 15 |
ddd | The abbreviated name of the day of the week. | 2009-06-15T13:45:30 -> Mon (en-US) |
dddd | The full name of the day of the week. | 2009-06-15T13:45:30 -> Monday (en-US) |
h | The hour, using a 12-hour clock from 1 to 12. | 2009-06-15T01:45:30 -> 1 2009-06-15T13:45:30 -> 1 |
hh | The hour, using a 12-hour clock from 01 to 12. | 2009-06-15T01:45:30 -> 01 2009-06-15T13:45:30 -> 01 |
H | The hour, using a 24-hour clock from 0 to 23. | 2009-06-15T01:45:30 -> 1 2009-06-15T13:45:30 -> 13 |
HH | The hour, using a 24-hour clock from 00 to 23. | 2009-06-15T01:45:30 -> 01 2009-06-15T13:45:30 -> 13 |
m | The minute, from 0 through 59. | 2009-06-15T01:09:30 -> 9 2009-06-15T13:29:30 -> 29 |
mm | The minute, from 00 through 59. | 2009-06-15T01:09:30 -> 09 2009-06-15T01:45:30 -> 45 |
M | The month, from 1 through 12. | 2009-06-15T13:45:30 -> 6 |
MM | The month, from 01 through 12. | 2009-06-15T13:45:30 -> 06 |
MMM | The abbreviated name of the month. | 2009-06-15T13:45:30 -> Jun (en-US) |
MMMM | The full name of the month. | 2009-06-15T13:45:30 -> June (en-US) |
s | The second, from 0 through 59. | 2009-06-15T13:45:09 -> 9 |
ss | The second, from 00 through 59. | 2009-06-15T13:45:09 -> 09 |
t | The first character of the AM/PM designator. | 2009-06-15T13:45:30 -> P (en-US) |
tt | The AM/PM designator. | 2009-06-15T13:45:30 -> PM (en-US) |
y | The year, from 0 to 99. | 0001-01-01T00:00:00 -> 1 0900-01-01T00:00:00 -> 0 1900-01-01T00:00:00 -> 0 2009-06-15T13:45:30 -> 9 2019-06-15T13:45:30 -> 19 |
yy | The year, from 00 to 99. | 0001-01-01T00:00:00 -> 01 0900-01-01T00:00:00 -> 00 1900-01-01T00:00:00 -> 00 2019-06-15T13:45:30 -> 19 |
yyyy | The year as a four-digit number. | 0001-01-01T00:00:00 -> 0001 0900-01-01T00:00:00 -> 0900 1900-01-01T00:00:00 -> 1900 2009-06-15T13:45:30 -> 2009 |
: | The time separator. | 2009-06-15T13:45:30 -> : (en-US) |
/ | The date separator. | 2009-06-15T13:45:30 -> / (en-US) |
\ | The escape character. | 2009-06-15T13:45:30 (h \h) -> 1 h |
Any other character | The character is copied to the result string unchanged. | 2009-06-15T01:45:30 (arr hh:mm t) -> arr 01:45 A |
Last updated
