AnsweredAssumed Answered

Date calculation question

Question asked by nancyhorne@centurytel.net on Sep 16, 2015
Latest reply on Sep 18, 2015 by nancyhorne@centurytel.net

I need help with the following date calculations. Help would be greatly appreciated!

 

Fields:

"frequency" which equals months, 6,12,24,48

training date

training date due = training date + frequency - one month (or 30 days)

 

1. If it is January how can I minus one month? I end up with an error.

 

2. I want the training date due color to change


For example:

Frequency = 12

Training date: 1/15/2014


Training date due  12/15/2014 to 1/15/2015 - normal color

Training date due  1/16/2015 to 2/15/2015 - orange

Training date due  2/16/2015 to 3/15/2015 - red

 

--

Thanks in advance!

Outcomes