I have the following code which adds part of the imported filename (filetoimport010420071530.txt) as (01042007) to a field
If the field is set to text it imports fine, but is not a date.
If the field is set to date it does not import anything.
If I dim FinalName as Date it imports as...