Qlikview : Max of date value

[#1]

Hi please help,

I have a value of date with the ff format :

2013-06-24 12:21:45

2013-06-24 12:21:46

i want to get the 2nd row with the value of "2013-06-24 12:21:46"

however using max function doesn't seem to work,

thanks for the input!

Note : i cannot change that date format, for i am filtering on all date and time aspect,, year-month-day-hour-min-ss

[Sokkorn · Accepted solution]

Hi,

Max function should work if your DateField is a proper date format. If it doesn't work, I assume that your DateField is a text format or else.

Let try =Date(Max(Date(Date#(DateField,'yyyy-MM-dd hh:mm:ss'))),'yyyy-MM-dd hh:mm:ss')

Regards,

Sokkorn

[#3]

date(Max(date(date#(datefield,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')))  as maxdate

*******************************************************************************************************************

or try this if your other field in table.

load

field1,

date(Max(date(date#(datefield,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')))  as maxdate

group by field1;