Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Time relative filters

cancel
Showing results for 
Search instead for 
Did you mean: 
nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

It would be great to see the addition of some new relative terms to the date filters.

Capture

As a daily user of Airtable, these terms would be useful from a reporting perspective:
Last Week - if it is week 23 now, then show my records from week 22.
Last Month - if it is June now, then show my records from May.
Last Quarter - if it is Q2 now, then show my records from Q1.
Last Year - if it is 2019 now, then show my records from 2018.
Thoughts?

3 Comments
JonathanBowen
13 - Mars
13 - Mars

Hi @nnnnneil - good suggestion.

A possible workaround for you in the interim:

Screenshot 2019-06-04 at 08.18.18.png

Create a field “Current Week” using the formula:

DATETIME_FORMAT(TODAY(), 'WW')

Then create a field which is the week that the record was added:

DATETIME_FORMAT({Record Added}, 'WW')

Take one from the other (“Week Diff”). You can now filter where the “Week Diff” = 1. You could come up with similar fields for month, year etc and hide in your view to reduce the clutter.

JB

nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @JonathanBowen, thanks for the suggestion. I guess i’m trying to keep my fields under control :slightly_smiling_face:

Chad_Smith
4 - Data Explorer
4 - Data Explorer

It also needs This Week, This Month