Hi, Tony - Thanks for your help.
Your solution was the same as one I had tried previously that did not work. So I realized I was at least on the right path, and the problem must lie elsewhere. I tried reformatting the time from "HHMM" to "HH:MM", as shown in your graphic, and it worked like a charm. Problem solved. I am embarrassed to think of the amount of time I spent trying to find a solution only to have it turn out to be so simple. I agree with you that the time setting - at least intuitively - should not make a difference, which is why I never tried changing it. But it seems that it does matter. Go figure. Thanks again for your help. Chuck On Sun, Mar 15, 2026 at 6:43 AM 'Tony IJntema' via RBASE-L < [email protected]> wrote: > > 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 > <https://groups.google.com/d/msgid/rbase-l/3a0b9cfb-eb29-42f4-b8be-32b591ce53ab%40cio-bv.nl?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/CADAyCN88wrOLhtMry9dsRex4_GWoOBgYvDABeRG1kdARrOnCtg%40mail.gmail.com.
