EasyMorph Help

This is an old revision of the document!

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'

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.