AnsweredAssumed Answered

Query XML for date field; store in variable or field

Question asked by sgeisbert on Sep 20, 2016
Latest reply on Sep 20, 2016 by emha

I am using the Query XML action to pull 7 different data elements from a repeating field in my list and then I am storing it in variables and eventually writing it to fields in a child list. I am able to pull all of the data (single lines of text, choice fields and number fields) and store the results in a variable; however, the date field shows as 1/1/001 12:00:00 AM when I write the variable to the history.

 

Here is how I am attempting to get and store the date:

 

I've tried storing the result in a variable of type date and of type string and neither works. The XML for the other data that I'm pulling looks exactly like this and works perfectly.

 

Any help is greatly appreciated. Thanks!

Outcomes