I have a table with separate date and time columns (shown below). I’ve specified that it should sort first by date ascending and then by time ascending. Note however, that ‘6:00 PM’ is listed before ‘10:00 AM’ on 4/6. Then on 4/7, ‘3:00 PM’ is listed after ‘10:00 AM’.
Is this a bug? Perhaps the table is setup incorrectly?
Thanks for any suggestions!