Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
My guess is the date format. Try converting it to a number:
Let vLast3Months = num(AddMonths(today(),-3));
My guess is the date format. Try converting it to a number:
Let vLast3Months = num(AddMonths(today(),-3));