Hi Charles

Select the proper column in the grid and then the properties.

Choose *Color*

It looks like this: (current time was 11:37)


Be careful with spaces and parentheses. In this case no spaces and parentheses yes

The time setting is not important I think. In my case the setting is: hh:mm:ss


Tony


Op 14-03-2026 om 17:38 schreef Charles Stevens:
Hello, all -

I am seeking collaboration on what should be a normal procedure but so far has eluded solution:

On a form I have a DB grid with a column named HOUR formatted as TIME. I want to change the background color for values which are less than the current time (overdue). Time is formatted as HHMM, 24 hours without spaces or delimiters. Under column properties, I have used the formula for the column HOUR "<(.#time)", together with all the variations I can think of for quotes and parentheses. Nothing works.

I am wondering if comparing time values is not possible (hardly seems realistic). Or am I missing some obscure detail?

I am hoping someone has solved a similar problem. Thanks in advance for any help.
--
**
*
*

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/CADAyCN-OUjWXcPf7VHbd3bZWqGV7-_awVe_9xc3kp_L9wc8h%3DQ%40mail.gmail.com <https://groups.google.com/d/msgid/rbase-l/CADAyCN-OUjWXcPf7VHbd3bZWqGV7-_awVe_9xc3kp_L9wc8h%3DQ%40mail.gmail.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion visit 
https://groups.google.com/d/msgid/rbase-l/3a0b9cfb-eb29-42f4-b8be-32b591ce53ab%40cio-bv.nl.

Reply via email to