Load only last X months - using a variable

[Anonymous]

Hi,

I want to load only data since last 3 months,

so in the script, I am using:

Let vLast3Months = AddMonths(today(),-3);

Table:

LOAD CampaignID,

          CreationDate as [ExportDate]

FROM XXX

WHERE CreationDate>=$(vLast3Months);   // I use $() since it's a date variable

But it's not effecting my load, what's wrong?

[Gysbert_Wassenaar · Accepted solution]

My guess is the date format. Try converting it to a number:

Let vLast3Months = num(AddMonths(today(),-3));