Smart Group's result sort by date

We can't troubleshoot unless you say in what way it doesn't work.

Then the user should go to the Editor, select the "All Macros" Smart Group (or a Group of interest), and sort by "Use Count". That information isn't directly available via AppleScript.

But you could take a look at some of the other recently-posted macros that list macro information -- one of those might do what you want by querying the database which stores that info. And keep an eye out for @DanThomas's forthcoming Macro Explorer, there's a usage count column in the screenshot.