convert string back to a date

MikeFrancis1959

I have a file that I need help on. I have a workflow that will remove the letters "ETA" from a column that is originally showing "ETA 06/30" or whatever date is in that column The formula that does this is the column called "Commit Date". But what I need help on is to convert that string a date.
Original format: column "Commit Date" formula will strip off "ETA" from column "2nd GI" if cell is like "ETA 06/30" and it leaves it as 06/30 but it is not a date. Other data is "Commit Date" is already a date because there was not "ETA" in the cell.
I am trying to get a formula to change the 06/30 to a date so another formula in the workflow will look at a date and then just show a month# like 6,8, etc.. any suggestions?
Mike

Tracker.yxzp

Workflow

Accepted answers

MikeFrancis1959

I attached the workflow and I included a snapshot. Currently the commit date will show 06/30 but the next formula I have in the workflow looks at the date and produces the month# that I use in another formula in the workflow. I have tried a few ways to make the string a date did not work.

Mike

Tracker.yxzp

binu_acs

@MikeFrancis1959 Updated your workflow and attached

Tracker.yxzp

Tracker.yxmd

All comments

binu_acs

@MikeFrancis1959 Can you provide some sample data and expected output? The SO_current and Rev_Type files were not uploaded properly in the zip file

MikeFrancis1959

Mike

Tracker.yxzp

binu_acs

@MikeFrancis1959 The two input files are not loading for me but I am able to create formula based on your screen shot

Also, you mentioned you have other values which are in proper format, in that case, you need to adjust the formula with some IF condition. Can you provide a sample file with both the dates included?