Max date in filter pane for bookmark

[MT4T]

Hi,

I have an issue with expressions to set up bookmark for pick latest date in filter pane.

I can not just use Today or similar functions. Data are archives of Turnover file which is not issued on daily basis.

I need bookmark in pair with sheet actions (trigger) to auto set default view on latest TO file breakdown.

My expression ' =max([file date.autoCalendar.Date])  ' , select all dates instead of max one. 

Strange is that same expression works as variable

[Or]

Perhaps:

=[file date.autoCalendar.Date]=max([file date.autoCalendar.Date])

[MT4T]

=[file date.autoCalendar.Date]=max([file date.autoCalendar.Date])

Also returns all values in my case (field is defined as date checked it)

[Or]

Usually that's a case of formatting - try date(max([file date.autoCalendar.Date]))

[MT4T]

Tryied date(max([file date.autoCalendar.Date])) with same result.

Bellow my "settings" for date. Maybe it will help to solve.

[Or · Accepted solution]

Sorry, that should have been:

=[file date.autoCalendar.Date]=Date(Max(all [file date.autoCalendar.Date]))

[Or]

[MT4T]

Thank you mate, problem solved.