Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
SET vMonth = Date(MonthStart(Today(), -6));
Load
*,
'$(vMonth)' as Validation_Month
Resident <<Table>>;