SharePoint Integration

Re: SharePoint 2010 Server add years to date field

BrianAdams — Thu, 02 Nov 2017 15:56:26 GMT

Thanks, the formula does work, I was putting it in the default value box instead of "The type of information in this column is:" section

Re: SharePoint 2010 Server add years to date field

Hilary Stoupa — Thu, 02 Nov 2017 15:14:10 GMT

Seems like it should work - the original field is a date datatype?

SharePoint 2010 Server add years to date field

BrianAdams — Wed, 01 Nov 2017 16:44:29 GMT

I need to add 2 years to a date field "D-SAACPCertificationDate" and display it in another field "D-SAACPExperationDate". I tried using the calculated field function in SharePoint Server list =DATE(YEAR([D-SAACPCertificationDate])+2,MONTH([D-SAACPCertificationDate]),DAY([D-SAACPCertificationDate])), but it errors. I tried several variations and breaking down into smaller parts. Any help will be appreciated. Thank you in advance