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
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.