Importing dates formatted "yyyy, mm, dd".

[Guest]

I'm experiencing problems when I try to import a date field. It's formatted:
yyyy, mm, dd (eg. "2005, 10, 07"). Is there a way to import this as a date
rather than text. And if I can't import as a date, how can I convert it to a
date once I import as text?

 

[Ken Snell [MVP]]

Import them as text initially. You then can use a query (append or update,
depending upon what you want to do) to convert to a date value (assuming
that all digits will always be in the "yyyy, mm, dd" format):

MyDateValue: DateSerial(Left([OriginalStringField], 4),
Mid([OriginalStringField], 6, 3), Right([OriginalStringField], 2))