Search…
⌃K
Links

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