AnsweredAssumed Answered

Putting dates in XML sets them back by 6 hours?

Question asked by andrew.x.childress@us.tel.com on Feb 3, 2017
Latest reply on Mar 28, 2017 by andrew.x.childress@us.tel.com

I have a pair of lists, ParentList and ChildList.  ParentList uses a Nintex form with a repeating section to track some dates.  There is a workflow on ParentList that parses the XML from the repeating section and turns each line of the repeating section into an item in ChildList.  ChildList has a workflow that grabs the XML from ParentList, takes the current date, updates an XML node called ClosureDate, and sticks the updated XML back in ParentList.  (It is set up like this, with two lists, so that users without permissions on ParentList can update the ClosureDate using ChildList.)

 

Here's the weird thing: every time a Date/Time variable gets passed from ParentList to ChildList, it seems to lose six hours.  So, for example, a "blank" date from the repeating section is saved as "01/01/1900 00:00:00" in ParentList, but when it is parsed out into ChildList it shows up as "12/31/1899 6:00:00 PM".  And when a closure date of 2/3/2017 is added to ParentList, it shows up back in ChildList as "2/2/2017 6:00:00 PM".

 

The variable is a Date and Time variable in both the form and the workflow.  We are in Central Standard Time.

 

Any ideas why this is happening? 

Outcomes