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,
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,
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
Maybe create a variable in script?
And use the variable in your expression
LET MaxDate= 'Max(Completed_Date)';
$(MaxDate) in front end
Retrieving data ...