Issue
When using a Date Time variable in a Workflow, the workflow might fail, generating multiple instances of the following error in ULS logs:
Nintex.Workflow.NWException: Failed to parse DateTime workflow variable into formatted string. Date is: <date and time>
Error Code
Nintex.Workflow.NWException: Failed to parse DateTime workflow variable into formatted string. Date is: 30/07/0029 00:00:00 ---> Microsoft.SharePoint.SPException: Cannot complete this action. Please try again. ---> System.Runtime.InteropServices.COMException: Cannot complete this action. Please try again.0x80004005 at Microsoft.SharePoint.Library.SPRequestInternalClass.TZConvertDate(Int64& pdate, Boolean bToLocalTime, UInt16 wTimeZoneID) at Microsoft.SharePoint.Library.SPRequest.TZConvertDate(Int64& pdate, Boolean bToLocalTime, UInt16 wTimeZoneID) --- End of inner exception stack trace --- at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.TZConvertDate(Int... 23b00b9e-6d2c-a042-07b4-9a57ddcdc856
Resolution
Make sure to have a date within the accepted range. By design SharePoint will not accept dates before 01/01/1900 or after 31/12/8900