Date field puzzle 1

[kupe]

I'd like to sort the files by the date field (DoA), when when it is used like this, how do I, please, Gurus?

... CONCAT(TO_DAYS(Curdate()) - TO_DAYS(DoA), 'days') AS LateBy ... ORDER BY LateBy DESC;

 

[TonyGroves]

You should be able to use[tt] ORDER BY doa DESC; [/tt]even if it's not included in the result set.

 

[kupe]

Brilliant, Tony. I was going to try that, but it seemed unlikely. Now I know better. Much obliged.