Get max date from selected dates

[ashishpalkar]

Hi There

I want to get max date from selected dates.

e.g I have field called 'Start Date'. When user selects multiple dates we want to display the max date from selected dates.

Thanks in advance,

[ToniKautto]

=Date(Max([Start Date]))

[ashishpalkar]

Hi Toni

thanks for responding, this is giving me Max date of the 'Start date'. How ever I want max date from user selected values.

Hope this helps, 

[diwaskarki]

Hello Toni,

Any idea why my script below is giving me a script error:

LOAD
AuditAutoFireOffices,
AuditAutoFireRequestee,
Date(Max(Completed_Date)),
(UPPER(AuditAutoFireOffices) & '.' & Upper(AuditAutoFireRequestee)) As 'Audit Correlation Key'
RESIDENT SPT_AUDIT_EVENT;

I appreciate the help. Thanks

[MK9885]

Maybe create a variable in script?

And use the variable in your expression

LET MaxDate= 'Max(Completed_Date)';

$(MaxDate) in front end