Forum Discussion
EvanMartinez
8 years agoModerator
Hi Kingsly,
Not a problem at all, I just wanted to make sure there wasn't a component missing that would change the response. For Part 4 you should be able to use a formula like below in a Formula-Date:
Not a problem at all, I just wanted to make sure there wasn't a component missing that would change the response. For Part 4 you should be able to use a formula like below in a Formula-Date:
This assumes that Template Type is a Text field and Start Date is a Date field. If Start Date is instead a Work Date field you may need to convert it to a Date field first using the ToDate conversion. I hope this suggestion is helpful Kingsly.
If([Template Type]="A" or [Template Type]="B", [Start Date]+Days(30),
If([Template Type]="C", [Start Date]+Days(60),
If([Template Type]="D",[Start Date]+Days(90),
If([Template Type]="E"[Start Date]+Days(120), null))))