Convert to date

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

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
 
Check Access HELP on the DateSerial() function, and the Left(), Mid() and
Right() functions.
 
Back
Top