Help

Re: How to create a filter with a date range? (e.g. filtered by past month)

1388 0
cancel
Showing results for 
Search instead for 
Did you mean: 
paulineeee
4 - Data Explorer
4 - Data Explorer

How to create formula that filter the rows by last month?

The filter function doesn't allow a date range (which is strange). 

e.g. If I want to filter rows with dates fall within February 2023, how do I do that?

 

Thanks a lot!

1 Reply 1

You could create a formula field and use filters off of that? 

Screenshot 2023-02-14 at 5.26.48 PM.png

And the formula used was `MONTH(Date) = MONTH(TODAY())`

Link to base