Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
tsbrian
Contributor II
Contributor II

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

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. 

Labels (2)
2 Replies
MatheusC
Specialist
Specialist

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

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
tsbrian
Contributor II
Contributor II
Author

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.