Date and Time Functions

[#1]

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]

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

Get the Dates Right

Automatic Number Interpretation

[its_anandrjs]

Check some of this

The Date Function

Date and time functions ‒ QlikView

[ravikumar_iyana]

Hi,

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

[Frank_Hartmann]

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]

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