Help

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

When you group fields by date to have the ability to choose if you want it to group by day, month or year

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

At the moment when you have a date column in a table and your group by date, it doesn’t allow you to chose if you want to group the entries by day, month or year. It just groups them by the date number.

I think it will be very useful to group it by month as I use Airtable to track my company’s expenses and I want to be able to group it by months as otherwise, I have too many entries.

3 Comments
Elias_Gomez_Sai
13 - Mars
13 - Mars

I think this is the expected, and you could create separated field for the 3 values with YEAR(), MONTH(), and DAY().

Kamille_Parks
16 - Uranus
16 - Uranus

Agreed, Airtable should allow that option for date fields. It’s a little silly that we have to make 3-5 fields (day, week, month, year, “complete” date) for one date to group things together.

If users want to track a start date and complete date they might need 10 fields to have flexibility in how records are grouped together as opposed to 2.

Dobs_Totev
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks i didn’t know this. For now it will work as a solution. But would be good if it was an option too :slightly_smiling_face: