Sorting by Date

Tagged: ,

Viewing 1 reply thread
  • Author
    Posts
  • May 11, 2021 at 6:14 PM #44359

    Yvette M
    Participant

    Can someone help me please!

    I, for the life of me, can not sort my data by date.

    Any examples? Or any obvious things I should know.

    I can attach my file if needed.

    Problem is it sorta by first number but not by month and year. So, I’ll have all January’s of both 2020 and 2021 together

    Thanks!
    Yvette

    May 11, 2021 at 10:16 PM #44363

    Brendan
    Keymaster

    Hello Yvette,

    Are you using a proper Date field in your form? Or are you using a Text field with date values in it? You need to use a proper Date field (or Date & Time).

    But to sort on your Date field, click the Form button, then the First Sort Field popup button. Select your Date field and then Tap Forms will automatically group your records by month and year. They will also be sorted chronologically.

    Thanks!

    Brendan

Viewing 1 reply thread

You must be logged in to reply to this topic.