Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vksthkkr
New Contributor III

Setting Date as variable in load script

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.

1 Reply
MVP
MVP

Re: Setting Date as variable in load script

Try this

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


Load

    *,

    '$(vMonth)' as Validation_Month

Resident <<Table>>;