User Tools

Site Tools


syntax:functions:format

Format(date_as_number, format)

Converts date_as_number into a text string according to format.

Example Result
format(41640,'yyyyMMdd') '20140101'
format(41640,'yy-MM-dd') '14-01-01'

Format string components

Case-sensitive.

Character Description
y The year, from 0 to 99.
yy The year, from 00 to 99.
yyyy The year as a four-digit number.
M The month, from 1 through 12.
MM The month, from 01 through 12.
MMM The abbreviated name of the month.
MMMM The full name of the month.
d The day of the month, from 1 through 31.
dd The day of the month, from 01 through 31.
ddd The abbreviated name of the day of the week.
h The hour, using a 12-hour clock from 1 to 12.
hh The hour, using a 12-hour clock from 01 to 12.
H The hour, using a 24-hour clock from 1 to 24.
HH The hour, using a 24-hour clock from 01 to 24.
m The minute, from 0 through 59.
mm The minute, from 00 through 59.
s The second, from 0 through 59.
ss The second, from 00 through 59.

See also

syntax/functions/format.txt · Last modified: 2016/08/22 11:42 by dmitry