FortiAnalyzer Date and Time built in macros

[tsimeonov_FTNT]

Description
This article describes the built in Time and Date macros in FortiAnalyzer.

Solution
Macros can be used on the FortiAnalyzer to fine tune report output.  Below is a list of macros which manipulate date and time formatting:

Macros	Description		Example
$hour_of_day	displays hour in 24 hrs format		18:00
$HOUR_OF_DAY	displays date (YYYY-MM-DD) and hour in 24 hrs format		2018-01-13 18:00
$day_of_week	displays number and name of the day of the week  (WDAY 2-Mon)		Mon
$day_of_month	displays day of the month in two digits format 01-12		01
$DAY_OF_MONTH	displays month in format YYYY-MM-DD		2018-01-01
$week_of_year	displays year and week of of the year		2018 Week-10
$month_of_year	displays month in format YYYY-MM		2018-12
$calendar_time	displays date and time in format YYYY-MM-DD HH:MM:SS, same as output from fuction from_itime(itime)		2018-01-13 18:36:06
$flex_timescale	Time scale changes according to the report time period: time period > 28 days                              time period > 12 hours and <= 28 days     time period > 4 hours and <= 12 hours     time period > 1 hour                                  <= hour		display day: 2018-02-25 display hour: 2018-02-25 14:00 display 30 min granularity: 2018-02-25 14:30 display 5 min granularity: 2018-02-25 14:40 display 1 min granularity: 2018-02-25 14:42

These macros have different output format in report and dataset tests. The table represents the report output format.