Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Any help with a variable that load last three months in current year variable.(including current date) to extract data.
Thanks
Something like this if your date field is named Date and has numeric date values:
LET vLimit = addmonths(today(),-3);
Table1:
load * from ...sourcetable...
where Date >= $(vLimit);
Hi!
I would add the function RangeMax () to ensure that only work with the current year.
LET vLimit = Date(Rangemax(YearStart(Today()), addmonths(Today(),-3)));