Converting string to date

Hi there,

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:
Capture

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


Capture2
Capture3
Capture6

Can anyone please help? It seems so simple but I can’t get it to work

Thank you.

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:

Original date:
Capture

Workflow:
Capture8

New date:
Capture9

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.