Format of text date

[Mitch]

I have an text import file with the date in the following format: yyyymmdd.
I need to move the year to the end so that it would look like mmddyyyy. I
have to leave this as a text field since I will be exporting the table to a
fixed width file. Any help would be appreciated.

Mitch

 

[Douglas J. Steele]

Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

 

[Mitch]

Douglas,

This prompts for a date. I have over 300 that have to be converted. Is
there a way to just move the year to the end of the date?

Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have an text import file with the date in the following format: yyyymmdd.
I need to move the year to the end so that it would look like mmddyyyy. I
have to leave this as a text field since I will be exporting the table to
a
fixed width file. Any help would be appreciated.

Mitch

 

[Douglas J. Steele]

That was a generic answer. You need to replace [TextDate] with your actual
field name.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

This prompts for a date. I have over 300 that have to be converted. Is
there a way to just move the year to the end of the date?

Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have an text import file with the date in the following format:
yyyymmdd.
I need to move the year to the end so that it would look like mmddyyyy.
I
have to leave this as a text field since I will be exporting the table
to
a
fixed width file. Any help would be appreciated.

Mitch

 

[Klatuu]

Using what? a query.
Where are you importing the text file to?
--
Dave Hargis, Microsoft Access MVP

Douglas,

This prompts for a date. I have over 300 that have to be converted. Is
there a way to just move the year to the end of the date?

Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have an text import file with the date in the following format: yyyymmdd.
I need to move the year to the end so that it would look like mmddyyyy. I
have to leave this as a text field since I will be exporting the table to
a
fixed width file. Any help would be appreciated.

Mitch