Is there a way to find most common date in list of dates?

Hi, this is kind of a fun math problem I’m trying to solve in Bubble. I have a list of users with dates of birth, and I’m looking for a way to calculate the month with the most birthdays in it. It seems like it should be easy but I can’t figure it out. Thanks!

Yes. You can use “count” and “group by” to process that in your query.

@ualdir could you elaborate? I actually can’t even see a group by option.

Screen Shot 2020-05-19 at 10.22.32 AM

1 Like

Bumping this back up as I still can’t figure out how to do this.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.