Numeric Date Value

[tmumaw]

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]

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 · Accepted solution]

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]

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

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

[QFabian]

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 '-'