Sorting by dual fields

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Sorting by dual fields

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • November 1, 2013 at 6:20 AM #7254

    Aaron Harmes
    Participant

    Hi
    I have a problem with a database I created on Tap Forms/Mac using a flight date and a flight time. I am trying to sort by the same date but 2 flight times(AM & PM). the sort comes out with the PM flight first no matter what I do….

    November 2, 2013 at 1:52 AM #7273

    Brendan
    Keymaster

    I think you’re better off using a Date & Time field for that instead of a separate Date and separate Time field. That way it can be sorted properly by date then time. The Date, Time, and Date & Time fields store both the date & the time to the database, but only display the time portion of it for a Time field, the Date portion for a Date field, and both for a Date & Time field.

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.