Adobe Acrobat Invalid data/time value

Adobe Acrobat Invalid data/time value

Hello Loraine Jey,

I have read your question and I understand the problem is causing for Microsoft Sharepoint.

You have to adjust the date/time value of After Properties in ItemUpdating/ItemAdding Events SharePoint.

Here is the method of changing date/time value

Methods to resolve the problem

1. Created a SharePoint Customer List
2. Add a new custom Column of type date/time (Example: Approved Time Stamp)
3. Created a Feature Receiver Event Handler Assembly implementing ItemUpdating/ ItemAdding event.
4. Try to assign value to the Datetime Column of After Properties in ItemUpdating/ ItemAdding event. If you assign value either of the below mentioned way it throws Error: "Invalid date/time value. A date/time field contains invalid data. Please check the value and try again."
5. properties.AfterProperties["ApprovedTimeStamp"] = DateTime.Now ;    //Generates Error
6. properties.AfterProperties["ApprovedTimeStamp"] = DateTime.Now.ToString();    //Generates Error
7. properties.AfterProperties["ApprovedTimeStamp"] = new DateTime(2008, 11, 08) ;    //Generates Error
8. properties.AfterProperties["ApprovedTimeStamp"] = DateTime.Now.ToLongDateString();    //Generates Error
9. properties.AfterProperties["ApprovedTimeStamp"] = DateTime.Now.ToShortDateString();    //Generates Error

When setting a date/time value in AfterProperties you have to change the date/time to an ISO8601 string format. Whichever of the line mentioned below can be used to assign value to date/time Column of Afterproperties in ItemUpdating/ ItemAdding Event:

• properties.AfterProperties["ApprovedTimeStamp"] = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ssZ");    // Works Fine
• properties.AfterProperties["ApprovedTimeStamp"] = Microsoft.SharePoint.Utilities.SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Now);    // Works Fine