topic How to work Date function without format parameters in QlikView

How to work Date function without format parameters

Kevderbeste — Sat, 16 Nov 2024 20:52:12 GMT

I was creating a calendar in order to supply the missing dates in my dataset.

I completed the information with autogenerate consecutive number asignment to any date, however I was trying understand it how to work date function without format parameter.

EX: date(43452) returns 18/12/2018

How is possible this simples numbers can be converted in a correct date, just with this function.

Re: How to work Date function without format parameters

Nicole-Smith — Tue, 14 May 2019 21:32:59 GMT

The integer is based on the number of days since 1899-12-30:

date(0)	30/12/1899
date(1)	31/12/1899
date(2)	1/1/1900
date(3)	2/1/1900
date(43452)	18/12/2018

Re: How to work Date function without format parameters

Vegar — Tue, 14 May 2019 21:56:18 GMT

The default format of the date is set by the DateFormat variable, normally autogenerated in the beginning of the
Script.

Example of use
SET DateFormat='YYYY-MM-DD';