Max Date

[qlikuser222]

  Hi, Can you please tell me how to get max date from the below dateformat??

Date

12/13/2016  13:00:00 AM

12/13/2016  14:00:00 AM

12/13/2016  13:00:00 AM

12/13/2016  13:00:00 AM

12/13/2016  13:00:00 AM

Thanks

[MarcoWedel]

14:00 AM ?

[shraddha_g]

Try

Timestamp(max(num(DateField)))

[jonathandienst]

None of those times are valid. A time can either be from a 24h clock (13:00, 14:00) or from a 12 hour clock (1:00 PM, 2:00 PM).