Dynamic Bookmark with dates greater than specific date (or between specific date and today)

[tsbrian]

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. 

[MatheusC]

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

[tsbrian]

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.