How do I sort data by date excluding time
 

I would like to sort a database by date and transaction type. The problem is
the data sorts by time, even though the field is formatted to show date only,
with the transaction type not sorting within the date because it shows up in
the time order. How do I get rid of the time?

How do I sort data by date excluding time
 

If date/time column is A then you have to use an empty helper column filled
with formula =INT(A2) and sort by it.

--
Regards!
Stefi



€žmarkd€� ezt Ã*rta:

I would like to sort a database by date and transaction type. The problem is
the data sorts by time, even though the field is formatted to show date only,
with the transaction type not sorting within the date because it shows up in
the time order. How do I get rid of the time?