Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 :
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
Got it to work. Thanks for your help. Here is what I did.
Let vNumStartDate = Num(Date('$(vStartDate)', 'MM/DD/YYYY'));
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 '-'