Parsing and then convert string to date

MikeFrancis1959

I have a date column for ship dates but many times it will not contain a date but will show "ETA 05/26"  when they anticipate the material will ship and what I am trying to do is parse this into 2 columns and then add "/2023" to the column and then convert to a date. I can parse the date and then add "/2023" but when I try to convert to a date it comes out 2023-01-26 and I don't know why it shows January instead of May, can someone look at point out where I went wrong? 

Thanks,

Mike

 Field1         Field11        Field12                   add year                      Date

ETA 05/26   ETA            05/26                        05/26/2023             2023-01-26

Parse then convert to date.yxzp

binu_acs

@MikeFrancis1959 You can try the below formula

DateTimeParse(toString(DateTimeYear(DateTimeToday()))+Replace([Field1],'ETA',''),'%Y%m/%d')

Parse then convert to date_240523.yxmd