topic need help on converting a date variable to integer in QlikView

need help on converting a date variable to integer

msmichael — Sat, 16 Nov 2024 04:49:17 GMT

Hi experts,

I have a variable that is bound to a calendar, the variable now has name as vCOB_DATE and value is 43465 (Dec 31st, 2018).

I have a field call COB_DATE which has Interger type (Not Date or TimeStamp types), so values in this field are like below:

COB_DATE

20180131

20180228

...

20181231

I need to convert the variable into the integer "20181231" and use it in a set expression as a filter, but I tried below seems it does not work..

{<[COB_DATE]={"=$(num#(date(vCOB_DATE, 'YYYYMMDD')))"}

Could you please help?

Thanks!

rwunderlich — Tue, 08 Jan 2019 21:15:22 GMT

You are close. You just have the = in the wrong place.

{<[COB_DATE]={"$(=num#(date(vCOB_DATE, 'YYYYMMDD')))"}

msmichael — Wed, 09 Jan 2019 02:41:48 GMT

Thank you Rob!