Q: My date field is embedded within text.  How do I import it?

 

Use a Custom Date Import (CDI).

 

From the main menu, select File, then Options, then General.

 
In the Import tab, set  "Custom Date Import (CDI) G/L:" to On

 
In "CDI: Source Format G/L", select your date format from the dropdown box  (31/12/2002, 2002/12/31, etc...)

 
In "CDI: Separator G/L", select your separator, (slash, colon, hyphen, none)

 
In "CDI: Embedded Start G/L" enter the date's first position (counting from the left) within the field.  For example, when date is in a field by itself, this position is 0. If there were three characters prior to the start of the date, you would enter 4.