CSV text to Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stacey - 23 Jan 2008 00:20 GMT

I have a file which I will be uploading into Access on a regular basis. The
date field is formatted to text which I would like to format into a date
field upon importing into Access. I would also like to rearrange the date
into a regular format, it reads as such 082101 and I would like it to read
01/21/08. Any help is greatly appreciated. Thanks in advance!

Stacey.

Reply to this Message

John W. Vinson - 23 Jan 2008 04:38 GMT

>I have a file which I will be uploading into Access on a regular basis. The
>date field is formatted to text which I would like to format into a date
[quoted text clipped - 3 lines]
>
>Stacey.

That's a VERY strange date convention: two digit year, then two digit DAY,
then two digit month? Are you certain that yesterday wouldn't have been
080121?

If it is as you post, then try

DateSerial(Left([textdate], 2), Right([textdate], 2), Mid([textdate], 3, 2))

If it is as I propose, swap places between the Right() and Mid() function
calls.

John W. Vinson [MVP]

Reply to this Message

Stacey - 23 Jan 2008 15:36 GMT

John, it worked. Thanks!!

> >I have a file which I will be uploading into Access on a regular basis. The
> >date field is formatted to text which I would like to format into a date
[quoted text clipped - 16 lines]
>
> John W. Vinson [MVP]

Reply to this Message