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).
@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?
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.