topic Re: Numeric Date Value in QlikView

Numeric Date Value

tmumaw — Fri, 15 Nov 2024 23:16:40 GMT

Good Morning Qliker's

I have a simple question. I have a date value 03/18/2020 that I need to make just this date numeric...any help.

Thanks

QFabian — Thu, 21 Jan 2021 12:46:37 GMT

Hi @tmumaw , a date in qlik is saved as a number, and if it is a timestamps, date and hour, the date is the number and the hour is the decimal part.

So if you just use num(DateField), you can see that Date as a number.

You can "format" too :

tmumaw — Thu, 21 Jan 2021 12:49:21 GMT

Here is what I have in my script. I need to make vStartDate numeric.

LET vStartDate = '03/18/2020';

Num(Date('$(vStartDate)', 'MM/DD/YYYY')) AS vNumWkend;

Thanks

tmumaw — Thu, 21 Jan 2021 12:54:02 GMT

Got it to work. Thanks for your help. Here is what I did.

Let vNumStartDate = Num(Date('$(vStartDate)', 'MM/DD/YYYY'));

QFabian — Thu, 21 Jan 2021 13:03:30 GMT

Excelent! @tmumaw , but you dont need to use the date function.

Just check if your initials system variables sday that your date separator is '/' or '-'