Only show future events

Viewing 2 reply threads
  • Author
    Posts
  • October 25, 2023 at 11:39 AM #50040

    Vaughan
    Participant

    Hi

    apologies if this has been covered before but I can’t find an answer

    iphone IOS 16.6.1

    Version 5.3.31 (1089)

    I have a form I use for upcoming events which I use to check off items I need to take with me

    the first field is the date of the event and I sort the forms with the smallest date at the top

    the problem I have is past events are at the top. I would like to try and filter out past events so the next future event is always at the top of the list.

    I tried to do this by filtering on the date so that it only shows dates equal to or greater than today but I can only seem to do this by a static date rather than today()

    can anyone help with this

    many thanks if you can

    October 27, 2023 at 12:38 PM #50052

    Brendan
    Keymaster

    hi Vaughan,

    You want to use the In the period comparison operator and then choose After today or Today or After.

    That’ll give you a dynamic filtered list of records by date.

    October 27, 2023 at 10:12 PM #50056

    Vaughan
    Participant

    Thankyou Brendan

Viewing 2 reply threads

You must be logged in to reply to this topic.