topic Re: Dynamic Bookmark with dates greater than specific date (or between specific date and today) in App Development

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

tsbrian — Fri, 15 Mar 2024 17:16:31 GMT

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.

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

MatheusC — Fri, 15 Mar 2024 20:11:49 GMT

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

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

tsbrian — Fri, 15 Mar 2024 20:39:56 GMT

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.