Date conversion, PLEASE HELP

[shawn]

I am importing data from an OBDC datasource. One of the
fields is a date field that imports in this
format "20040818", as a number. I am trying to convert
this value to a date format and have had no luck. If
anyone can provide assistance, I am grateful...

 

[Ken Snell [MVP]]

MyDate = DateSerial(Left([ImportedDate], 4), Mid([ImportedDate], 5, 2),
Right([ImportedDate], 2))

 

[Guest]

MANY,MANY THANKS!! Works perfectly.

-----Original Message-----
MyDate = DateSerial(Left([ImportedDate], 4), Mid ([ImportedDate], 5, 2),
Right([ImportedDate], 2))


--

Ken Snell
<MS ACCESS MVP>

I am importing data from an OBDC datasource. One of the
fields is a date field that imports in this
format "20040818", as a number. I am trying to convert
this value to a date format and have had no luck. If
anyone can provide assistance, I am grateful...

.

 

[Ken Snell [MVP]]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

MANY,MANY THANKS!! Works perfectly.

-----Original Message-----
MyDate = DateSerial(Left([ImportedDate], 4), Mid ([ImportedDate], 5, 2),
Right([ImportedDate], 2))


--

Ken Snell
<MS ACCESS MVP>

I am importing data from an OBDC datasource. One of the
fields is a date field that imports in this
format "20040818", as a number. I am trying to convert
this value to a date format and have had no luck. If
anyone can provide assistance, I am grateful...

.