Bookmark max date in filter pane

[MT4T]

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:

And field which i wanna filter throught filter pane is:

[Mark_Little]

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]

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

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

[Aurelien_Martinez]

Hi,

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

Aurélien

[MT4T]

This still do not solved my problem.

It seems like format or field is the issue.

[MT4T · Accepted solution]

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))"}>}