Differences

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

--- l2_report_time_formats [2019/02/22 15:38] – [Hour, minute, second tokens] emozolyak
+++ l2_report_time_formats [2019/02/22 16:26] – [Time format modifiers used in Level2 report builder] emozolyak
@@ Line 1: / Line 1: @@
 ====== Time format modifiers used in Level2 report builder ======
-===== Locale aware formats =====
+When you place cells with time values in the report you need to specify format string for them.
+Then the special 'token' characters will be looked for to determine how to display the time.
+E.g. in //h:m:s// string for duration h, m and s charachters will be replaced with the duration "weights" in hours, minute and seconds respectively, separated with the ':'. Please refer to the following tables for time and duration format specifiers.
+{{ ::time_modifiers.png?direct |}}
+Please refer to the below tables for token characters:
+===== Time =====
+==== Locale aware formats ====
 ^Input	^Example	^Description^
@@ Line 11: / Line 22: @@
 |LTS	|08:30:00 PM	|Time (with seconds)|
-===== Hour, minute, second tokens =====
+==== Year, month, and day tokens =====
+^Input	^Example	^Description^
+|YYYY	|2014	|4 or 2 digit year|
+|YY	|14	|2 digit year|
+|Y	|-25	|Year with any number of digits and sign|
+|Q	|1..4	|Quarter of year. Sets month to first month in quarter.|
+|M MM	|1..12	Month number|
+|MMM MMMM	|Jan..December	|Month name in locale set |
+|D DD	1..31	Day of month|
+|Do	|1st..31st	|Day of month with ordinal|
+|DDD DDDD	|1..365	|Day of year|
+|X	|1410715640.579	|Unix timestamp|
+|x	|1410715640579	|Unix ms timestamp|
+==== Hour, minute, second tokens ====
 ^Input	^Example	^Description^
@@ Line 23: / Line 48: @@
 |Z ZZ	|+12:00	|Offset from UTC as +-HH:mm, +-HHmm, or Z|
+===== Time duration formatting ======
+The template string is parsed for moment token characters, which are replaced with the duration's value for each unit type. The moment tokens are:
+<code>
+years:   Y or y
+months:  M
+weeks:   W or w
+days:    D or d
+hours:   H or h
+minutes: m
+seconds: s
+ms:      S
+</code>
+Escape token characters within the template string using square brackets.
+E.g.
+<code> h [hrs], m [min] </code> format string will result in such output: "2 hrs, 3 mins".