time

[master_student]

Hello,

I need  to display time only if it is >= 13:00:00

If(TIME (DATE_DEB)>'13:00:00', TIME (DATE_DEB), '')

How to do it?

Thanks

[sunny_talwar]

May be this:

If(Time(DATE_DEB) > MakeTime(13), Time(DATE_DEB))

[Digvijay_Singh]

If(TIME (DATE_DEB)>13/24, TIME (DATE_DEB), '')

[Chanty4u]

try this

If(TIME (Field)>'13:00:00', TIME (Field),Time(Field)) as new

[master_student]

it didn't work sunny.

or how to get the maximum time of the DATE_DEB, I tried this exp : MAX (Time(DATE_DEB)), it didn't work

DATE_DEB has this '19/09/2016 13:00:00'

[sunny_talwar]

How about this:

If(Time(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss')) > MakeTime(13), Time(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss')))

[master_student]

nope. and the maximum time of the DATE_DEB field. any idea?

Thanks

[sunny_talwar]

In the script or front end? What are the dimensions?

[tresesco]

Try like:

Time(MAX (Frac(DATE_DEB)), 'hh:mm:ss')

[master_student]

in the front end