Calculating Due Dates by Month then turning text RED
I found this scrpting for calculating due dates by days:
VariableDueDate2 = Date (Month (StartDate), Day (StartDate) + NumberOfDays, Year (StartDate))
If I wanted to do it by months (minus one month) would it be:
VariableDueDate2 = Date (Month (StartDate) + (NumberOfMonths) - 1, Day (StartDate), Year (StartDate))
how then would I get the text to turn another color once it hits that date?