Differences

This shows you the differences between two versions of the page.

--- syntax:functions:format [2018/08/18 22:34] – dmitry
+++ syntax:functions:format [2019/12/06 04:45] – andrew
@@ Line 1: / Line 1: @@
-===== Format(date_as_number, format) =====
+===== format(date_as_number, format) =====
-Converts //date_as_number// into a text string according to //format//.
+Converts //date_as_number// into a text string according to a //format// string.
-^  Example  ^  Result  ^
+^  Example  ^  Result  ^  Notes  ^
-|  format(41640,'yyyyMMdd')  |20140101  |
+|  format(41640,'yyyyMMdd')  |20140101  | 41640 corresponds to January 1st, 2014  |
-|  format(41640,'yy-MM-dd')  |14-01-01  |
+|  format(41640,'yy-MM-dd')  |14-01-01  | 41640 corresponds to January 1st, 2014  |
 === Format string components ===
-Case-sensitive.
+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).
 ^  Character  ^  Description  ^
 |  y  |The year, from 0 to 99.  |
@@ Line 29: / Line 34: @@
 |  s  |The second, from 0 through 59.  |
 |  ss  |The second, from 00 through 59.  |
+|  tt  |The localized AM/PM designator.  |