User Tools

Site Tools



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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
l2_report_time_formats [2019/02/22 15:38]
emozolyak [Hour, minute, second tokens]
l2_report_time_formats [2022/01/15 06:34] (current) ↷ Links adapted because of a move operation
Line 1: Line 1:
 ====== Time format modifiers used in Level2 report builder ====== ====== 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. 
 +{{ network:time_modifiers.png?direct |}} 
 +Please refer to the below tables for token characters: 
 +===== Time ===== 
 +==== Locale aware formats ==== 
 ^Input ^Example ^Description^ ^Input ^Example ^Description^
Line 11: Line 22:
 |LTS |08:30:00 PM |Time (with seconds)| |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^ ^Input ^Example ^Description^
Line 23: Line 48:
 |Z ZZ |+12:00 |Offset from UTC as +-HH:mm, +-HHmm, or Z| |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:
 +years:   Y or y
 +months:  M
 +weeks:   W or w
 +days:    D or d
 +hours:   H or h
 +minutes: m
 +seconds: s
 +ms:      S
 +Escape token characters within the template string using square brackets.
 +<code> h [hrs], m [min] </code> format string will result in such output: "2 hrs, 3 mins".