Load: Max Date-Time field

[#1]

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

[sunny_talwar]

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

[swuehl]

Why don’t my dates work?

[#4]

Thanks Guys,

School boy error...It turns out my input was text.

Thanks

Gary