Converts date_as_number into a text string according to a format string.
|format(41640,'yyyyMMdd')||20140101||41640 corresponds to January 1st, 2014|
|format(41640,'yy-MM-dd')||14-01-01||41640 corresponds to January 1st, 2014|
A format string defines a formatting template for dates. Its components can be put together in any combination. If a character doesn't belong to a format component then it's inserted verbatim.
Note that the colon (“:”) is not a valid symbol for file names and therefore mustn't be used in file names generated using a format string.
Attention The format components are case sensitive. For instance, “MM” (uppercase) and “mm” (lowercase) are frequently confused by new EasyMorph users but they denote different data/time components (see table below).
|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.|
|tt||The localized AM/PM designator.|