topic MakeDate as a number in QlikView

MakeDate as a number

bimartingo — Wed, 11 Apr 2012 11:59:09 GMT

Hi, need some help on date / Makedate

If i read a excel file with a "date" column (number formated as a date) into a variable, this variable get's the number representing the date.

If i create a variable with makedate(yyyy,mm,dd) i get dd/mm/yyyy ( my date mask is DateFormat='DD/MM/YYYY' )

how do i do to create this variable as a number, like i had got reading from the excel file?

I believe this question of variables and the use of them in code and set expresssions is very confusing.

swuehl — Wed, 11 Apr 2012 12:19:56 GMT

If you want to convert your date to a number, use

Let vDate = num(makedate(yyyy,mm,dd));

in your variable definition. (Or num('$(vDate)') in any expression using your original variable should work, too.)

Or use date() function to format your excel date field:

...

Date(EXCELFIELD) as Date,

...

Hope this helps,

Stefan

jagan — Wed, 11 Apr 2012 12:28:22 GMT

Hi,

Use Num() to convert date to number format.

Regards,

Jagan.