Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
=Date(Max([Start Date]))
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,
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
Maybe create a variable in script?
And use the variable in your expression
LET MaxDate= 'Max(Completed_Date)';
$(MaxDate) in front end