# Trouble with filtering by date (Airtable) **URL:** https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235 **Category:** Ask for Help **Created:** [May 1, 2023, 7:20pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235 "2023-05-01T19:20:43Z") **Posts on this page:** 6 **Page:** 1
### Author: ![Hal\_Atkins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hal_atkins/32/44352_2.png) [@Hal\_Atkins](https://community.glideapps.com/u/Hal_Atkins) #### Post date: [May 1, 2023, 7:20pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/1 "2023-05-01T19:20:43Z")
Good afternoon- Starting to work with data in our Airtable base - I want to filter a collection by a date field in Airtable (Date Received). When trying to set up that filter in the Glide editor, I’m not seeing a way to filter it by a custom set of dates (ideally, looking to filter for records within the last year). ![Screenshot 2023-05-01 at 3.18.42 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c4ccab72cdd37c04cbd2ca3064659bf99d74d9a1.png) Is there a way to choose something other than “today” or “now”? ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [May 1, 2023, 7:25pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/2 "2023-05-01T19:25:16Z")
Create a math column in Glide using the formula `Now-365`, where Now is replaced with the current date/time. Then your filter can be “where Date is after math column”. ---
### Author: ![Hal\_Atkins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hal_atkins/32/44352_2.png) [@Hal\_Atkins](https://community.glideapps.com/u/Hal_Atkins) #### Post date: [May 1, 2023, 7:27pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/3 "2023-05-01T19:27:53Z")
@Darren_Murphy Thanks for the help! Following up on your solution - I would create a math column in a Glide table? Would it be best to just have a Glide table that would create these kinds of variables? ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [May 1, 2023, 7:33pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/4 "2023-05-01T19:33:12Z")
Yes, using a [math](https://www.glideapps.com/docs/reference/computed-columns/math-column) column. > [@Hal\_Atkins](#): > > Would it be best to just have a Glide table that would create these kinds of variables? Not exactly sure what you are getting at there. Do you mean additional “preset” values for things like “1 week ago”, “1 year ago”, etc? That sort of thing isn’t really necessary, as you can define any date/period that you want with a bit of date math. ---
### Author: ![Hal\_Atkins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hal_atkins/32/44352_2.png) [@Hal\_Atkins](https://community.glideapps.com/u/Hal_Atkins) #### Post date: [May 1, 2023, 7:40pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/5 "2023-05-01T19:40:10Z")
Yeah - was just trying to think of other uses for this Glide table (not currently using Glide tables, as all of our data is currently in Airtable). ---
### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system) #### Post date: [May 2, 2023, 7:40pm UTC](https://community.glideapps.com/t/trouble-with-filtering-by-date-airtable/61235/6 "2023-05-02T19:40:29Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.