topic Re: Date and Time Functions in QlikView

Date and Time Functions

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

day( '1971-10-12' ) returns 12

day( '35648' ) returns 6 ( Because 35648=1997-08-06 )

Can anyone explain how QlikView interprets 35648 as '1997-08-06' in case of Date and Time Functions?

swuehl — Sat, 30 Sep 2017 21:12:30 GMT

It's explained in these two blog posts (and also have a look at the linked material):

its_anandrjs — Sun, 01 Oct 2017 05:16:25 GMT

Check some of this

ravikumar_iyana — Sun, 01 Oct 2017 07:11:21 GMT

Hi,

In our Qlikview is already inbuilt Date() for easily converting purpose

Frank_Hartmann — Sun, 01 Oct 2017 08:14:35 GMT

Date Starting Point in Qlikview is:

=num(Date('31.12.1899','DD.MM.YYYY')) = 1

So for every additional day the num value increases in value 1

So if you add 35648 days then you meet your date

Anonymous — Mon, 02 Oct 2017 13:13:05 GMT

if you use the expression

DATE(1) AS [FIRST DATE]

you wil see, the first date considered by qlikview is 31/12/1899.

All the dates are counted since this date