Linking txt field - can't convert to date format

[mmartin999]

I cannot get this field to come in as a date format xxxx/xx/xx. it is held in the format yyyymmdd so when I link the file I specify it is a date/time field and on the advanced tab I select YMD and check "4 digit years" but the data comes in as #NUM!. I want it to show up as MMDDYYYY What am I doing wrong??
thanks

 

[Joe4]

On the Advanced Tab, did you also remove the Date Delimiter?