Expression to filter on latest date

[dan205]

Is there an expression I can use in a [date] filter pane search field to select the latest date for which data has been loaded?

I tried =Max([date]) and =MaxString([date]) but they don't work. 

My date field is loaded from a SQL date field: YYYY-MM-DD.

Thanks,

Dan

[Javizh · Accepted solution]

Hello Dan.

Try this "=date = max(total date)"

Best regards.

[Mark_Little]

=Num(Date)=Num(Max(ALL Date))

Possibly don't need the NUM()

[BrunPierre]

Ensure that the [date] field is recognized as a date field.

=Date(Max([date]), 'YYYY-MM-DD')

[dan205]

Thanks Javizh.