Not applicable

Query XML for date field; store in variable or field

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!

0 Kudos
Reply
3 Replies
emha
Automation Master
Automation Master

Re: Query XML for date field; store in variable or field

can you post how does your source XML loooks like?

0 Kudos
Reply
Not applicable

Re: Query XML for date field; store in variable or field

TestTE - All Items

Your response made me take another look at the XML and I realized that I had the field name incorrect so thank you! It's working perfectly now!
0 Kudos
Reply
emha
Automation Master
Automation Master

Re: Query XML for date field; store in variable or field

glad pointing you to the right direction.

consider marking the topic answered.

0 Kudos
Reply