Variable Definition

[grgabj]

I have a calendar which when i choose a riskcarrier it gives me the max date, this is the function:

=date(max([LASTREFRESH_DATE]))

but when i select a specific date in the calendar the variable definition gives me numbers : 44628 

why? 

i want to be able to select a specific date , but when i re select a specific filter i want it to give me my variable ( max date ) , it just goes away and it gives nothing , it gives the selected date in the calendar that i chose. Please help

[Or]

Max(Field) will give the max value of the field for the current selections. If you'd like the overall max value ignoring selections, use Max({1} Field) or Max(ALL Field)

[grgabj]

That's not it , I need to be able to get the max bi filter , but once i select a date from the calendar , the date is saved as the calendar date and the variable is gone , so once i repick a filter , the date doesnt give the max anymore ! 

[SchalkF]

Hello,

Try this:

=date(max([LASTREFRESH_DATE]), 'dd/mm/yyyy')