Possible to convert "05012008" to a Date?

[PW]

Doesn't look like Access 2003 has many date functions or a character
to date function.

Any ideas?

Thanks,

-paulw

[PW]

Re: Possible to convert "05012008& quot; to a Date?

On Fri, 16 May 2008 13:29:17 -0600, PW
<paulremove_wil liamson858@remo vehotmail.comwr ote:

>Doesn't look like Access 2003 has many date functions or a character
>to date function.
>
>Any ideas?
>
>Thanks,
>
>-paulw

I think I got it using DateSerial IF I can convert "05012008" to
"080501" (May 1st 2008)

-pw

[PW]

Re: Possible to convert &quot;05012008& quot; to a Date?

On Fri, 16 May 2008 14:00:21 -0600, PW
<paulremove_wil liamson858@remo vehotmail.comwr ote:

>On Fri, 16 May 2008 13:29:17 -0600, PW
><paulremove_wi lliamson858@rem ovehotmail.comw rote:
>

>>Doesn't look like Access 2003 has many date functions or a character
>>to date function.
>>
>>Any ideas?
>>
>>Thanks,
>>
>>-paulw

>
>I think I got it using DateSerial IF I can convert "05012008" to
>"080501" (May 1st 2008)
>
>-pw
>
>

Nevermind. I have the client save the XLS into yyyymmdd and use
DateSerial.

Thanks

-pw