+7
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:
+17
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 - Td{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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.