Differences

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

--- l2_report_time_formats [2019/02/22 15:36] – emozolyak
+++ l2_report_time_formats [2019/02/22 16:03] – [Duration] emozolyak
@@ Line 1: / Line 1: @@
 ====== Time format modifiers used in Level2 report builder ======
-===== Hour, minute, second tokens =====
+When you place cells with time values in the report you need to specify format modifier for them.
+{{ ::time_modifiers.png?direct |}}
+Please refer to the below tables:
+===== Time =====
+==== Locale aware formats ====
+^Input	^Example	^Description^
+|L	|04/09/1986	|Date (in local format)|
+|LL	|September 4 1986	|Month name, day of month, year|
+|LLL	|September 4 1986 8:30 PM	|Month name, day of month, year, time|
+|LLLL	|Thursday, September 4 1986 8:30 PM	|Day of week, month name, day of month, year, time|
+|LT	|08:30 PM	|Time (without seconds)|
+|LTS	|08:30:00 PM	|Time (with seconds)|
+==== 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 13: / Line 43: @@
 |Z ZZ	|+12:00	|Offset from UTC as +-HH:mm, +-HHmm, or Z|
+===== Duration ======
+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. "h [hrs], m [min]" format string will result in such output: "2 hrs, 3 mins".