Skip to main content

Date and time functions

QlikView date and time functions are used to transform and convert date and time values. All functions can be used in both the load script and in chart expressions.

Functions are based on a date-time serial number that equals the number of days since December 30, 1899. The integer value represents the day and the fractional value represents the time of the day.

QlikView uses the numerical value of the parameter, so a number is valid as a parameter also when it is not formatted as a date or a time. If the parameter does not correspond to numerical value, for example, because it is a string, then QlikView attempts to interpret the string according to the date and time environment variables.

If the time format used in the parameter does not correspond to the one set in the environment variables, QlikView will not be able to make a correct interpretation. To resolve this, either change the settings or use an interpretation function.

In the examples for each function, the default time and date formats hh:mm:ss and YYYY-MM-DD (ISO 8601) are assumed.

Information note

When processing a timestamp with a date or time function, QlikView ignores any daylight savings time parameters unless the date or time function includes a geographical position.

For example, ConvertToLocalTime( filetime('Time.qvd'), 'Paris') would use daylight savings time parameters while ConvertToLocalTime(filetime('Time.qvd'), 'GMT-01:00') would not use daylight savings time parameters.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Integer expressions of time

Timestamp functions

Make functions

Other date functions

Timezone functions

Set time functions

In... functions

Start ... end functions

 

Day numbering functions

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com