variable

[upaliwije]

Hi Friends,

I want to crate variable from the following syntax

LET vMonth=num#(Date(Makedate(2019,11,30),'YYYYMM'));

my expected result is   201911

But it does not work as expected. Pls help me to correct it

[DavidM · Accepted solution]

Why do you need num#?

LET vMonth=Date(Makedate(2019,11,30),'YYYYMM');

Also you don't need the day if you're creating only year and month Makedate(2019,11) is enough