Display Time In Different Color

[Fred in Thailand]

Here I Go Again,

I Have a field "StartTime" type TIME

I would like it to Display Red if the Value is greater than 08:15:00.

I am sure it needs to be done with a text format calc but can't get it to work.

If (StartTime>08:15:00; TextColor ( StartTime; RGB ( 255; 0; 0) )) Result=Text

That displays all records as red. Help Please I have tried every permutation i can think of.

[Lee Smith]

First of all , you are trying to use a Text Formating Functions with a Time Field.

Try:

Case ( StartTime ≥ Time ( 8 ; 15 ; 0 ) ; TextColor ( GetAsText ( StartTime ) ; RGB ( 250 ; 0 ; 0 ) ); GetAsText ( StartTime ); TextColor ( StartTime ; RGB ( 0 ; 0 ; 0 ) ))

HTH

Lee

[Fred in Thailand]

Thanks again Lee,

As usual, works like a dream.

Someday I will learn how the case, let, if... etc work.

I new it had to do with working with the time field and changing it to text with the GetAsText function. I tried to use it but couldn't figure out how.

Thanks again.