Format of text date

  • Thread starter Thread starter Mitch
  • Start date Start date
M

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,

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?

Douglas J. Steele said:
Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mitch said:
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
 
That was a generic answer. You need to replace [TextDate] with your actual
field name.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mitch said:
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?

Douglas J. Steele said:
Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mitch said:
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
 
Using what? a query.
Where are you importing the text file to?
--
Dave Hargis, Microsoft Access MVP


Mitch said:
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?

Douglas J. Steele said:
Format(CDate(Format([TextDate], "####-##-##")), "mmddyyyy")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mitch said:
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
 
Back
Top