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

How to eliminate the time stamp in a Repeating Section XML Query for Date?

How do you eliminate the time stamp in a Repeating Section XML Query for "Date"?  I have the date field in the list set to date only.  I have the control set to Yes (show only the date).  Is the issue because I am querying the date in an XML call?

I am building an HTML table which then populates back to the list:

"<td style='text-align: left; vertical-align: middle;'>{WorkflowVariable:queryLicenseIssueDate}</td>"

But this is what displays:

0 Kudos
Reply
1 Reply
Community Manager Community Manager
Community Manager

Re: How to eliminate the time stamp in a Repeating Section XML Query for Date?

This is funny, I had a similar issue before and it was a pain to remove. The way I did this was a workaround and it worked but it was around, haha.

 

Extract that date from the XML, through it into a variable, and then use RegEx to strip out just the date. You can do this by just getting the date, removing the ending time, or by capturing the beginning digits minus the time stamp.

 

Here is an example regex - T\d{2}:\d{2}:\d{2}Z and a link to an article about it https://stackoverflow.com/questions/43349687/remove-time-part-from-a-datetime.

 

Let me know if that helps.

Eric

0 Kudos
Reply