Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

maximum time

Hello everyone

please how to get the maximum time of a date field that has this format : 12/06/2013 12:33:55

Thanks in advance

18 Replies
Chanty4u
MVP
MVP

try

  1. LOAD 
  2.   *, 
  3.   Date(Floor([Field])) AS [%Maxtime];
robert_mika
Master III
Master III

Try

max(time(yourfiled))

d.PNG

susovan
Partner - Specialist
Partner - Specialist

You can also try this below expression,

=Date#(Now())

Warm Regards,
Susovan
master_student
Creator III
Creator III
Author

it displays the date not the time. see bellow :

Capture.PNG

master_student
Creator III
Creator III
Author

I don't need the maximum time in absolut. for example I had DATE_DEB that contains

12/01/2016 12:00:12

12/01/2016 08:00:12

12/01/2016 14:00:12


I need to get : 14:00:12

antoniotiman
Master III
Master III

Hi Wiem,

if You have more dates

12/06/2013 12:33:55
13/06/2014 12:20:40

Max(Time(Date))  -> 12:20:40
Time(Max(Frac(Date)))   -> 12:33:55

Regards,

Antonio

Anonymous
Not applicable

Hi

=Max(Time(Your Date Field))

Hope it helps!!

master_student
Creator III
Creator III
Author

didn't work in my case. see bellow :

Capture.PNG

master_student
Creator III
Creator III
Author

I need the maximum time of only one date