Rolling 3 month 1

[mcdac1]

I have a report which we only want the last three months of data from the date it's ran. So if I run it today June 9 it will have all data back to March 9. Thanks for your help.

 

[blom0344]

How do you define 3 months in your case?

One possible solution:

extract(day,current_date-[somenamespace].[somedate])
between
(CASE
     WHEN
         extract(month,current_date) in (1,7,8,10,12)
     THEN 92
     WHEN
         extract(month,current_date) in (2,4,6,9,11)
     THEN 91
     WHEN
         extract(month,current_date) in (3,5)  
     THEN 90
     ELSE 89 
END)

Ties Blom