i have 3 years of data with date field , but i need last 3 months of data Excluding current month.
for EX:- now April month is current month but i need "JAN,FEB,MARCH"
once if enter to "MAY" month i need "FEB,MARCH,APRIL" data.
create variable in script like
while loading data use variable in where clause
where Date>=$(vLast3MonthStartDate) and Date<=$(vLastMonthEndDate)
I will suggest dont use expression as its lower the performance.
I already face issue on same.
Go by dreamer4 way suggested.
Define variables and pass to scripts.
That will faster performance while you loading data.
This all when you have high amount of data.
if you want to select you can used below equation
='('& Date(monthname ( Today()),'MMM') & '|'& Date(monthname ( AddMonths(Today(),-1)),'MMM')& '|'& Date(monthname ( AddMonths(Today(),-2)),'MMM')& ')'