Hi,
I have a database that tracks inspection due dates on industrial equipment. What I want to do is conditonally format the text boxes, so that any inspection that comes due on the next calendar month is highlighted green. For example:
Today is 21-Aug-2012. If a piece of equipment has an inspection due in September, I want the text box displaying the inspection date to be highlighted green.
Any help would be appreciated, thanks!