How do I sort data by date excluding time

  • Thread starter Thread starter markd
  • Start date Start date
M

markd

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?
 
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:
 
Back
Top