I would like to convert a Date to another format.
I already read some other topics about this, but still I am not very good at this.
The format is as such:
Wednesday, July 26, 2017 - 7:12 AM EDT
I would like to convert it to
I need the day, month and year separated so I will split them afterwards.
I removed "Wednesday, " and " - 7:12 AM EDT"
so “July 26, 2017” remains. It is not a very unusual format so it shouldn’t be very hard to convert it.
I already tried this:
Td4 is the Generic Value variable.
When I do this, the error “Assign : The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.” is shown.
Is there anyone that can help me with this? There are really similar topics but still I can’t get it done.
Thank you in advance!