I’ve been trying to figure this out myself, but after a lot of searching, reading and testing, I am realising that this might be above my current abilities.
What I am trying to achieve is pretty straight forward on paper.
I have two dates variables:
This is the date format they output:
I need to covert that %Variable%From% and %Variable%To% into an American date format and I need that info to be outputted into two new variables such as %Variable%FromUS% and of course %Variable%ToUS%
This would be the text outcome of those new variables:
@gglick has provided you with the solution, but FYI the "US" format that you asked for is generally known as the "ISO" or "International" format: "YYYY-MM-DD"
The typical U.S. (American) format is that given by "MM/DD/YYYY":