DOMO SQL MAX(date) not working
hello, hope someone could help on my SQL:
I just created a simple SQL under DOMO MySQL to select some fields and the MIN and MAX of a date, like:
SELECT `id`, `name`, min(`a_date`) as 'oldest date', max(`a_date`) as 'latest date'
GROUP BY `id`, `name`
but nothing is returned in the 2 date fields, original dataset contain a valid date value in all rows.
I tried to simply select the MIN or MAX date without GROUP BY, it works properly, but it returns null once with GROUP BY. Any idea and solution?
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部