Report order by date format doesns't work

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

hi to all, i’m trying to create a report, grouped by date_start and ordered by crdate_start eate_date with the format d/m/y.

but this doesnt work because the query he make is:
ORDER BY DATE_FORMAT(meetings.date_start + INTERVAL 0 MINUTE,'%d/%m/%Y') ASC

the date_format convert to string, so is useless try to order by date if the format is a string. there is a way to fix this?

Versione 7.10.22

Sugar Versione 6.5.25 (Build 344)