Adding number of days to Date - Formula Field

Question

Hello:Your friendly yet persistent novice with another question:I am trying to add days to a date - formula field based on selection in a different field.Error Message:Formula syntax errorPlease check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.if([Work Type]="RD-Reactive",([Date Complete WO Received]+Days(5)),[Work Type]="PJ-Planned Job",([Date Complete WO Received]+Days(12)),  [Work Type]="RP-Reactive Project",([Date Complete WO Received]+Days(10)),)Any help would be greatly provided&nbsp;Dirk

quickbasecoachd · Answer

The problem is that there was an extra comma at the end

if(
[Work Type]="RD-Reactive",([Date Complete WO Received]+Days(5)),
[Work Type]="PJ-Planned Job",([Date Complete WO Received]+Days(12)),
[Work Type]="RP-Reactive Project",([Date Complete WO Received]+Days(10))
)

but this also can be simplified to

Case([Work Type],
"RD-Reactive", [Date Complete WO Received]+Days(5),
"PJ-Planned Job", [Date Complete WO Received]+Days(12),
"RP-Reactive Project",[Date Complete WO Received]+Days(10))

dirkruana · Answer

Dan:Thank you for quick response!I tried both, but still not seeing results in [Target End Date] field.No formula error messages.Dirk

quickbasecoachd · Answer

On an example record, what date is in the field for&nbsp;[Date Complete WO Received]&nbsp;and what value is on the field for[Work Type]&nbsp;

dirkruana · Answer

Dan:All good!&nbsp; Just a slight formatting issue on my part.Thank you so much.&nbsp; I am so envious of your skills.Dirk

quickbasecoachd · Answer

no problem, Thx for letting me know it works.

Forum Discussion

Adding number of days to Date - Formula Field