{"id":41828,"date":"2018-11-14T17:39:51","date_gmt":"2018-11-14T12:09:51","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=41828"},"modified":"2018-11-14T17:39:51","modified_gmt":"2018-11-14T12:09:51","slug":"qlik-sense-date-and-time-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-date-and-time-functions\/","title":{"rendered":"Qlik Sense Date and Time Functions – Syntax and Example"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last Qlik Sense tutorial, we discussed Qlik Sense Integer Functions<\/a><\/strong>. Today, we will see Qlik Sense Date and Time Functions. We use the date and time functions in Qlik Sense to process and evaluate the date and time data values present in the data records. Basically, we use these functions both in the script and chart expressions. Each time and date value since December 30, 1899 has a unique serial number (i.e. number of days from December 30,1899) whose integer part represents the day and fractional value represents the time of that day. So, when Qlik Sense evaluates these functions, the date and time values are taken up as numerical values.<\/span><\/p>\n

So, let’s start Qlik Sense Date and Time Functions.<\/p>\n

\"Qlik<\/a>

Qlik Sense Date and Time Functions – Syntax and Example<\/p><\/div>\n

Have a look at Qlik Sense Mathematical functions\u00a0<\/a><\/strong><\/p>\n

2. Qlik Sense Date and Time Functions<\/h2>\n

Following are the Qlik Sense Date and Time Functions, let’s discuss them in detail –<\/p>\n

i. Timestamp functions<\/span><\/h3>\n

These functions return timestamps in specific situations. <\/span><\/p>\n

a. Now() function<\/span><\/h4>\n

The Now() function returns the current time as a timestamp from the system\u2019s clock. This function returns value in dual data type. <\/span><\/p>\n

Syntax:<\/strong><\/p>\n

now([timer_mode])<\/pre>\n
Where the <\/span>timer_mode<\/span> can assume three values, i.e. 0 (returns the time of last completion of data load), 1 (returns the time of a function call) and 2 (returns the time when the app was opened). The default value is set at 1.<\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n