Date fields store dates in the db in the form of “YYYYMMDD’ so you need to use “CHAR” or “NUMBER” as the field click.
I am not sure how time fields store values, you should check the DB to be sure.
But if you have the right data format then sorting by the two fields should work.
