I have a complicated form situation. I'm trying to have it calculate when a person can start working on a report (Date C) based on the day a project ends (Date A) and the day the report is due (Date B). We have a set scale for when the Date C should be based on the difference between
The form has 2 dates that are entered by the user (Date A and Date B). I managed to calculate the difference between Date A and B that gives you a numeric value ( x days ). I need the form to calculate a third date (Date C) in that range based on the length of days between Date A and B.
Calculating Date C
if x days is ≥ 90 days
then Date C = Date B - 15 days
ifx days is ≥ 30 and ≤ 89 days
then Date C = Date B - 10 days
if x days is ≥ 29 days ≤ 10 days
then Date C = Date B - 5 days
ifx days is > 10 days
then Message pop-up (We cannot accept an [x days value] less than 10 days without manager approval.)
From what I understand FormCalc is better with dates but I'm not as experienced with that language and I know I'm missing things.