+4It would be great to see the addition of some new relative terms to the date filters.
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?
+18Hi @nnnnneil - good suggestion.
A possible workaround for you in the interim:
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
+4Hi @nnnnneil - good suggestion.
A possible workaround for you in the interim:
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
Hey @JonathanBowen, thanks for the suggestion. I guess i’m trying to keep my fields under control :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
