Trying to get Dell warranty expiration dates to show up from an XML file that was created. Below is set up to get the dates.
unique values of (it as trimmed string) of node values of selects "endDate/text()" of selects "/List/item/entitlements/entitlement" whose( exists (it) whose(it < current date OR it > current date) of ((it as date) of (last 2 of it & " " & (substring (4,2) of it as integer as month as three letters) & " " & first 4 of it) of it) of (it as trimmed string) of (concatenations of substrings separated by "-" of it) of (preceding text of first "T" of it) of node values of selects "endDate/text()" of it ) of xml documents of files "BigFixDellWarranty.xml" of folders "Dell" of folder "ProgramData" of drive of system folder
It is reporting back with a date but adding a string of numbers and letters after, and in some returning multiple results, image below.
I need this to just return back with a date format of MM/DD/YYYY. I have checked the XML file and the end date does have the extra numbers and letters after it. Is there a way to cut it out and just return the date?