Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Variable Creation

Dear Friends

I have created a variable

vN1=Num(Date(Makedate(2017,12,01),'YYYYMM'))   Expected result=201712

How ever it  does return the expected result. Kindly Help to get it corrected

2 Replies
sunny_talwar

Try this

vN1 = Num#(Date(Makedate(2017,12,01),'YYYYMM')) 
marcus_sommer

Num() is wrong because it made from your formatted date a number again. Therefore just leave it:

vN1 = Date(Makedate(2017,12,01),'YYYYMM')

- Marcus