maximum time

[master_student]

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

[Chanty4u]

try

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

[robert_mika]

Try

max(time(yourfiled))

[susovan]

You can also try this below expression,

=Date#(Now())

[master_student]

it displays the date not the time. see bellow :

[master_student]

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]

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]

Hi

=Max(Time(Your Date Field))

Hope it helps!!

[master_student]

didn't work in my case. see bellow :

[master_student]

I need the maximum time of only one date