When sorting by the Date/Time column the results are often baffling. For instance, if sorted by date and all order are left in for the month of June, the days of the month with single digits sort correctly while the days of the month in double digits sort TO THE TOP.

It appears the Date/Time field is not numeric? Is this a known issue?

I like to keep the orders log throughout the month and delete them at the end of the month in case I need to audit manual entries versus the system generated orders.

Maybe it's a string sort (haven't had a chance to test it though).