Date range expression

I am trying to create a SLICE of data based on a date range.  I have two date fields: START DATE and END DATE.  I have trouble creating the ROW FILTER CONDITION (True/false expression that checks if a row should be included in the slice). 
I would like to include the data that has a START DATE between the range of 30 days in the past and 30 days in the future from today OR an END DATE between the range of 30 days in the past and 30 days in the future from today.  In other words, if today is September 22, 2022, I would like to filter data that has a date of August 22, 2022 to October 22, 2022 either in the START DATE or END DATE field.
I've tried many options but nothing seems to work.  
This expression does not work:
OR ([START DATE]>= DATE(Day(Today())-30),[END DATE]>= DATE(Day(Today())-30)

Any help would be welcomed !

Solved Solved
0 2 120
1 ACCEPTED SOLUTION

Maybe this?

OR(

AND ([START DATE]>= TODAY()-30,[START DATE]<= TODAY()+30),

AND ([END DATE]>= TODAY()-30,[END DATE]<= TODAY()+30)

)

 

View solution in original post

2 REPLIES 2

Maybe this?

OR(

AND ([START DATE]>= TODAY()-30,[START DATE]<= TODAY()+30),

AND ([END DATE]>= TODAY()-30,[END DATE]<= TODAY()+30)

)

 

Thanks so much.  It worked perfectly !

Top Labels in this Space