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!
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!
You could create a formula field and use filters off of that?
And the formula used was `MONTH(Date) = MONTH(TODAY())`
Link to base
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.