Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
vN1 = Num#(Date(Makedate(2017,12,01),'YYYYMM'))
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