Last 3 months variable

[Anonymous]

Hi,

Any help with a variable that load last three months in current year variable.(including current date) to extract data.

Thanks

[Gysbert_Wassenaar]

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);

[felipe_dutra]

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)));