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

[ualdir]

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