Variable

[upaliwije]

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

[sunny_talwar · Accepted solution]

Like I mentioned in the other thread... try with Num#() instead of Num()

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

[Gysbert_Wassenaar · Accepted solution]

Remove the Num function. That just removes the formatting that the date function first added. You can use the num# function, but since you assign it to a variable it will make no difference if you do that or not. The variable will contain 201712 in either case.