Date from imported data

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I am new to Access and need to create a date from 20100207 in a query that I
am making. In Excel it goes Date(left(),mid(),right()) to come up with
02/07/2010.
I have joined 3 files from an accounting SQL database to import sales data
into Access.
Thanks for any help and I know I will have more questions.
Lee
 
You didn't suggest whether the value you have is string or numeric. Access
VBA uses DateSerial() rather than Date(). The remainder should be easy for
you to figure out.

Duane Hookom
MS Access MVP
 
Thanks for the point in the right direction. It worked well with the
left,mid,right parts added.
Thanks again.
Lee
 
Back
Top