[pilot-db-list] Sorting Times and Dates

[Michael A. L. <mic...@ma...>]

Sunday, March 13, 2005, 17:51

Dear pilot-db users,

  I made a simple DB for logging events during a day. Three columns,
  Date, Time and String, using current Date and Time as defaults.

  After a few days writing things, I inserted a few entries related to
  earlier dates and times. So I had to sort them.

  But to my sad surprise, I found that sorting by Time or Date does
  NOT sort chronologically. I just sorts them all wrong.

  (Try for yourself to understand what I mean).

  How can I have Date and Time entries be sorted correctly? And since
  Date is in one column and TIme is in another one, how can I have
  them work together when sorting? Is there a way to have Date AND
  Time in the same field?

Regards,

Michael A. Lees
mic...@ma...


-------------------
Random quote:
Hold a hard drive to your ear and listen to the C.
 - Unknown