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

[Anonymous]

Did you try my expression? It will work

[master_student]

no it didn't

[Peter_Cammaert]

Use only the date as dimension and Max(Time(DateTimeField)) as expression. Max() is an aggregation function to be used in a table expression.

You can wrap all identical dates together using a calculated dimension like: Date(Floor(DateTimeField))

[#5]

Hi,

Do you want Max time of all the records in all fields??

try

max(time(total DATE_DEB)

HTH,

Abdul

[Peter_Cammaert]

You can't use Max() in calculated dimensions, at least not without aggr().

[master_student]

I need to set a condition in my expression to display the time only if it is >13:00:00 and <14:00:00

If(time(DATE_DEB)>'13:00:00', and time(DATE_DEB)>'13:00:00', '')

any idea please

[susovan]

Try this also,

=Time(Now())

[MarcoWedel]

please post some sample data and your expected result

thanks

regards

Marco

[Anil_Babu_Samineni]

I don;t think what you are expecting, here you are posting issue is different to now? Can you please post the sample application which demonstrates the expected o/p?

Anyway, try this

If you really have DATE_DEB has 12/06/2013 12:33:55 format, then might you will get below

Aggr(Date(Date#(If(Timestamp(Timestamp#(DATE_DEB,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss' > Timestamp(MakeTime(13:00:00),'hh:mm:ss') < Timestamp(MakeTime(14:00:00),'hh:mm:ss')), 'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'), DATE_DEB)