Convert to date

[news.microsoft.com]

Hi
I have a table of data that has been supplied to me where the date fields
are in the format 1041231 - this would be 31st December 2004 i.e ignore the
1 at the beginning.

How can I convert this field in to date field?

Thanks

 

[Jeff Boyce]

Check Access HELP on the DateSerial() function, and the Left(), Mid() and
Right() functions.

 

[news.microsoft.com]

Thanks - Works a treat