topic Load: Max Date-Time field in QlikView

Load: Max Date-Time field

Fri, 16 Oct 2015 15:30:39 GMT

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 — Fri, 16 Oct 2015 15:33:40 GMT

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 — Fri, 16 Oct 2015 15:37:21 GMT

Wed, 25 Nov 2015 09:32:15 GMT

Thanks Guys,

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

Thanks

Gary