
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2022 07:41 AM
Hello, We have a table set up which has several fields. We need to send a few of the fields to our finance team which we have worked out how to group but the key thing is to isolate the data by month. We can see that you can filter dates but not by actual month it would appear? We don’t want past month or future month as that can cross over 2 months(14th Jan-14th Feb). I would have thought that if you picked within these dates you could use a calendar to select say 1/1/22-31/1/22? However only option appears to be to select from the drop down list. It seems such a simple request so must be able to do it. Any help would be appreciated, driving me a bit mad. Thanks, Nick
Read more
REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 14, 2022 09:44 AM
This is one of those odd missing features in Airtable. I personally have a helper field with the formula:
DATETIME_FORMAT({Your Date Field}, 'YYYY-MM')
