Posted by Scott Currie on December 28, 2000 7:03 AM
I am looking for some help....I am trying to create a function that will do the following:
I have a column with a service date (12/28/00)-and-
a column with a service interval (say every 3 months)
I want to change 12/28/00 to RED when the true date is 14 days or less of the 3 month date.
If work was done on 12/28/00 and next service is 3/28/01, when I am at 3/20/01; 12/28/00 will go RED.
Any help would be GREATLY appreciated.