Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
Try
max(time(yourfiled))
You can also try this below expression,
=Date#(Now())
it displays the date not the time. see bellow :
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
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
Hi
=Max(Time(Your Date Field))
Hope it helps!!
didn't work in my case. see bellow :
I need the maximum time of only one date