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?