Custom Date Formats
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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
