mmartin999
New Member
- Joined
- Oct 4, 2006
- Messages
- 33
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
thanks