4 Replies Latest reply on May 7, 2015 5:40 PM by ChrisWelsh_1

    Calculating Due Dates by Month then turning text RED

    ChrisWelsh_1

      Title

      Calculating Due Dates by Month then turning text RED

      Post

      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?

      Thanks