Please help me format a text field as a date. I have the following inception dates listed as text fields in yyyymmdd format. I want to change them into dates. For example, 20110726 becomes 7/26/2011. The expression Format([Inception_date],"mm/dd/yyyy") is giving me a Num! error.