cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Date/time error in Due date Assign Task action.

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.

Natasja Martens

Labels: (1)
0 Kudos
Reply
2 Replies
Not applicable

Re: Date/time error in Due date Assign Task action.

HI Natasja,

     Bcoz of incorrect date format you got this error...You can calculate the date from workflow itself..just follow these steps..

  1. Create one date/time variable...
  2. You Need to capture the runtime date follow the snapshot

Step1.png

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

step2.png

I hope this may be somewat helpful for u

Reply
Not applicable

Re: Date/time error in Due date Assign Task action.

Thanx, I mis interpreted the function of the 'add time to date' action. I didn't recognise it as a date-calculator. I thought that it would add only hh.mm.ss to a date.

0 Kudos
Reply