Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to set up a default bookmark so that when users open up the app, all data is pre-filtered so that they see records from 12/1/2023 and later.
My approach has been to figure out the filter search string that would make this work and then bookmark that. I'm having a hard time figuring out the search string to enter into the filter's search. Using the following string works for filtering a single day:
{<"=Date(Floor([MEDIA_CREATED]))"={'12/1/2023'}>}
I can't figure out how to make this so that it shows all values greater than 12/1/2023.
Hi, @tsbrian
As a suggestion, try adding date formatting to the script.
In the date filter panel test this:
=[MEDIA_CREATED]>=MakeDate(2023,1,12) AND [MEDIA_CREATED]<=Today()
Regarts, Matheus
Thank you @MatheusC.
I'm not sure what you mean by "...try adding date formatting to the script". The [MEDIA_CREATED] is a date set up using AutoCalendar definitions.
Putting your recommended statement in the filter didn't produce any data. I even tried one condition at a time and I get no matches.