Setting Date as variable in load script

[vksthkkr]

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.

[sunny_talwar]

Try this

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

Load

    *,

    '$(vMonth)' as Validation_Month

Resident <<Table>>;