I built a Nintex Workflow for Office365 workflow for the payment approval of received invoices.
The due date of the approval action now suspends the workflow with the following notification:
RequestorId: 56eb0983-8ffd-34b3-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ArgumentException: The conversion could not be completed because the supplied DateTime did not have the Kind property set correctly. For example, when the Kind property is DateTimeKind.Local, the source time zone must be TimeZoneInfo.Local. Parameter name: sourceTimeZone at System.TimeZoneInfo.ConvertTime(DateTime dateTime, TimeZoneInfo sourceTimeZone, TimeZoneInfo destinationTimeZone, TimeZoneInfoOptions flags, CachedData cachedData) at System.TimeZoneInfo.ConvertTimeToUtc(DateTime dateTime, TimeZoneInfo sourceTimeZone) at System.Activities.CodeActivity`1.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation) Exception from activity ConvertTimeZone If Sequence DynamicActivity<DateTime> Werkstroomvariabele instellen Yes Right=above €500 Left is below €500 Sequence Flowchart InvoiceApproval.WorkflowXaml_adbbed76_1226_44bb_bc04_6038455eea9f
First It worked: I had set the due date with a lookup of the date/time column 'PayBy' (Date only)
But I wanted to set the due date one week earlier then the 'PayBy' date.
Because I don't find an action in Nintex Workflow to calculate dates, I added a calculated column to the list.
This has got value =[payby]-7
Datatype Date/Time / Date only
The column is calculated and filled correctly in the list.
Now the workflow fails...
I already tried to fill a workflow variable 'dDuedate' (datatype Date/Time) with the LookUp to the column 'InvoiceApprovalDueDate' and then use this to set the Action Due date.
Is this a known error? What's wrong? Any solutions?
Thanks a lot.
Bcoz of incorrect date format you got this error...You can calculate the date from workflow itself..just follow these steps..
3.In Nintex O365 itself you can able to calculate the dates using "Add Date&Time" Action Under operations tab it available..then follow the snapshot to calculate(add) the date
I hope this may be somewat helpful for u