I am trying to convert a string to a date and it simply will not work and I don’t know why.
The original date field looks like this:
And I wrote a workflow to extract the year, month and day and resorted it and concatenated them together into a string but when I go to convert string to date, it keeps giving me an error
I managed to solve my own problem but replying here incase it helps anyone else!
I figured I don’t need to extract any fields. I just used the ‘Modify Time Zone’ and ‘Modify Time’ and removed the attributes I didn’t need to leave simply the date: