Setting Date as variable in load script

vksthkkr — Wed, 25 Nov 2020 16:16:04 GMT

I am setting a variable to a date value in the load script as below

LET vMonth = MakeDate(Year(Today()),Month(Today())-6,1);

At a later point in the script, i am setting a filed in a table using this variable

Load

$(vMonth) as Validation_Month

Resident <<Table>>;

While the variable seems to be set properly, the $ sign expansion seems to be returning a value of -21.

Not sure why this is happening.

Re: Setting Date as variable in load script

sunny_talwar — Wed, 11 Jul 2018 19:44:44 GMT

Try this

SET vMonth = Date(MonthStart(Today(), -6));

Load

'$(vMonth)' as Validation_Month

Resident <<Table>>;