Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Afternoon,
I have a field (TransactionDate) that is a date and time ('DD/MM/YYYY HH:MM;SS')
I need to return the Max(TransactionDate)
At the moment the above function is not returning an answer.
The function also needs to be load script friendly.
Thank you in advance!
Cheers
Gary
Maybe your date is not recognized as a date, Try this:
TimeStamp(TimeStamp#(TransactionDate, ''DD/MM/YYYY hh:mm:ss')) as TransactionDate
and then use Max(TransactionDate) for a numbered result or TimeStamp(Max(TransactionDate)) for Timestamp result
Thanks Guys,
School boy error...It turns out my input was text.
Thanks
Gary