Help

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

Additional filters for "Created Time" field

cancel
Showing results for 
Search instead for 
Did you mean: 
Aerienne_Russel
5 - Automation Enthusiast
5 - Automation Enthusiast

When setting up filters based on a โ€œCreated Timeโ€ field, I would love if there were more options, such as:

  • month / year created
  • within [insert time frame between two dates]
  • within [past week, past month, past year, etc]

For example, I added a ton of records to my Airtable on 6/21/21 and then again on 6/24/21. I only want to view those records, so it would be great to be able to filter for
โ€œCreated Timeโ€ โ†’ month created = June
or
โ€œCreated Timeโ€ โ†’ date is between = 6/21/21 - 6/24/21

2 Comments
Kamille_Parks
16 - Uranus
16 - Uranus

Created time fields have the same filter options as other date-type fields. If you want to set up a view filter as described, use a formula field with outputs like the following:

MONTH({Created time})

or

IF(DATETIME_FORMAT({Created time}, 'YYYYMM') = DATETIME_FORMAT(TODAY(), 'YYYYMM'), "current month")

For โ€œdate is betweenโ€ you could use two โ€œis on or beforeโ€ view filters.

Aerienne_Russel
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for the suggestion! I havenโ€™t played much with the formula fields, and didnโ€™t know about the MONTH feature, so that is very helpful!

In terms of the second suggestion about the โ€œis on or beforeโ€ view filter, I didnโ€™t realize that the โ€œisโ€ was a drop-down filter you could adjust in addition to the other view filter fields. That pretty much solves all of my questions.

Thank you!!