Load only last X months - using a variable

Anonymous — Mon, 31 Aug 2015 15:38:55 GMT

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?

Re: Load only last X months - using a variable

Gysbert_Wassenaar — Mon, 31 Aug 2015 15:46:18 GMT

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

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