variable

upaliwije — Fri, 04 Oct 2019 14:01:31 GMT

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

Re: variable

DavidM — Fri, 04 Oct 2019 14:15:14 GMT

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