Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
MT4T
Creator
Creator

Bookmark max date in filter pane

Hi,

I recently changed the date format in my app. My old bookmark broke.

I have tried a lot of versions from the internet or modified by me but it does not work.

There are so lot options and I have no clue where i should start.

Is there ani universal guide to how to use this type of expression? 

My current date format is on bellow screens:

MT4T_0-1661921011178.png

MT4T_1-1661921056812.png

 

And field which i wanna filter throught filter pane is:

MT4T_4-1661921174397.png

 

Labels (2)
1 Solution

Accepted Solutions
MT4T
Creator
Creator
Author

At the end I decided to rename my field from ( "[Date([file date]])]" or "Date [file date]") to "file_date".

Apparently, the name was too complex and wierd.

And bellow expression worked:

=Num(file_date)=Num(Max(ALL file_date))

bellow is bookmark version of expression:

{<"=Date(Floor([file_date]))"={"=Num(file_date)=Num(Max(ALL file_date))"}>}

 

View solution in original post

5 Replies
Mark_Little
Luminary
Luminary

Hi @MT4T 

 

Can you not just select in Field type the expression =Max("Date [file date]"), apply it and create a new Bookmark.

Then apply as default if needed?

 

MT4T
Creator
Creator
Author

Unfortunately this =Max("Date [file date]") not works at all.

Modified to =max([Date([file date]])]) marks all available dates.

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

I tried an expression like this: =Date='$(=Max(Date))'

 

amartinez35_1-1661936658550.png

Aurélien

 

Help users find answers! Don't forget to mark a solution that worked for you!
MT4T
Creator
Creator
Author

This still do not solved my problem.

It seems like format or field is the issue.

MT4T
Creator
Creator
Author

At the end I decided to rename my field from ( "[Date([file date]])]" or "Date [file date]") to "file_date".

Apparently, the name was too complex and wierd.

And bellow expression worked:

=Num(file_date)=Num(Max(ALL file_date))

bellow is bookmark version of expression:

{<"=Date(Floor([file_date]))"={"=Num(file_date)=Num(Max(ALL file_date))"}>}