Hello everybody! last evening I was trying to solve a tiny problem in base but didn't succeed !! Could it be that there is no built-in function to extract the date part of a datetime field??
I have to set up a query in OO-base like this one. In "mysql dialect" it would be SELECT DATE(`datetime-field`) AS `workdate`, SUM(`field-2`), SUM(`field-3`), .... FROM `Another-Query` WHERE .... GROUP BY `workdate` ORDER BY `workdate` DESC Couldn't find a proper way. Or am I just blind ?? Norbert -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
