Skip to main content

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

  • February 14, 2023
  • 1 reply
  • 44 views

Forum|alt.badge.img

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

TheTimeSavingCo
Forum|alt.badge.img+31

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

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

Link to base