|
You may need to set the correct date format:
The macros may work incorrectly if the incorrect date format is specified.
You can select the date format from the list os predefined date formats or specify it as a string value. See the next table for details:
String Value | Example |
---|---|
d - day of month (no leading zero) | 1 |
dd - day of month (two digits) | 01 |
D - day of week | Mon |
w - week of year (no leading zero) | 1 |
ww - week of year (two digits) | 01 |
m - month of year (no leading zero) | 1 |
mm - month of year (two digits) | 01 |
M - month name short | Jan |
MM - month name long | January |
y - year (two digits) | 19 |
yy - year (four digits) | 2019 |
Qi - quarter (Q+digit) | Q1 |
hh - hour (two digits) when using a 24-hour time format | 01 |
HH - hour (two digits) when using a 12-hour time format | 01 |
mm - minute (two digits) | 01 |
ss - second (two digits) | 01 |
o - day of the year (no leading zeros) | 1 |
oo - day of the year (three digits) | 001 |
If you use the string value for setting the date format, you can combine and customize them to your needs, as follows:
Table Filter
In the page view mode
|
In the macro browser
Pivot Table
Chart from Table
Table Transformer
|
You can set the dynamic time intervals in the date picker in the Table Filter macro in the following format:
If you need to set some complex interval, enter it as a single string, like: -2m 3w 5d. The current browser date is used as a starting date for data filtration according to the specified time intervals.