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

deliriousmiles · 2020-05-18T23:57:16.290Z

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!

ualdir · 2020-05-19T12:40:18.657Z

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

deliriousmiles · 2020-05-19T20:23:18.546Z

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

Screen Shot 2020-05-19 at 10.22.32 AM

deliriousmiles · 2020-07-07T20:14:39.992Z

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

system · 2020-07-28T00:04:05.850Z

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