cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
furstlars
Nintex Newbie

How do I clear the XML empty date value of 1/1/1900?

Jump to solution

The issue: a null date field in a repeating section gets thrown into the XML as 01/01/1900 00:00:00.

Extremely frustrating; it's shocking how Nintex can't even deal with an issue like this, automatically?

How do I update the XML so it clears the field? I'm not familiar with XPath so any guidance would be appreciated.

Labels: (1)
0 Kudos
Reply
4 Replies
emha
Nintex Newbie

Re: How do I clear the XML empty date value of 1/1/1900?

Jump to solution

simple XPath like this should do the trick

//DateControlName

Reply
mmatsako
Nintex Newbie

Re: How do I clear the XML empty date value of 1/1/1900?

Jump to solution

Marian's solution directly answers your question, but another thought:   Are you feeding the XML directly into something (usually we use XPath to retrieve the important parts, or some other means to simply ignore the values on the receiving end)? Unless you need the XML itself to be pristine surrounding empty dates, there are many work around.  Just curious how you are utilizing the XML itself.

Another thought is that if the form is ever updates/changes, I believe the current XML will be overwritten, so you'd have to rerun the Xpath to overwrite the values again (just keep this in mind if the form gets modded).

Reply
furstlars
Nintex Newbie

Re: How do I clear the XML empty date value of 1/1/1900?

Jump to solution

I figured it out by introducing a calculated value on the form with the following function:

formatDate(DateControlName,'dd/MM/yyyy'), only then will Marian's suggestion work. Otherwise it wouldn't.

0 Kudos
Reply
emha
Nintex Newbie

Re: How do I clear the XML empty date value of 1/1/1900?

Jump to solution

Hi Furst, could you clarify what exactly you mean with that?

how can one additional calculated control influence whether DateControlName XML node is cleared or not in workflow?

0 Kudos
Reply