I'm trying to get my completed date field to update based on my plan review schedule. This is what I have come up with but getting an error. Any help is much appreciated.
thanks,
IF(VALUEOF([Plan Review Schedule],"Quarterly"),DATEADD(DAY, 90, [Completed Date])
IF(VALUEOF([Plan Review Schedule],"Semi-annual"),DATEADD(DAY, 180, [Completed Date])
IF(VALUEOF([Plan Review Schedule],"Annual"),DATEADD(DAY, 365, [Completed Date])))))
Darren, you posted this on the NetWitness group, fyi, so your answers might be limited here. Putting on my Archer hat for a minute, I believe (if this is an exact copy) that your two issues might just be:
1) The lack of commas at the end of the first two rows.
2) You don't have a final THEN statement. So, "If Quarterly, Add 90 days, If Semi-Annual, Add 180 days, If Annual, Add 365 days," but what if none of those is chosen? Even if the field is a VL with only those options available, you'll potentially have blanks or other mistaken values. A simple "" to return a null value should work.