MS Access data conversion - inported data in 20050131 format to a table how can i change to 1/

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

inported data in 20050131 format to a table how can i change to 1/

Access Newbie looking for help

2005-08-23, 8:25 pm

I imported data that is in Year Month Day format and saved this data as a
table.

How can I change this format to Month / Year format.

Douglas J. Steele

2005-08-23, 8:25 pm

Presumably you're storing it in a text field. Add a Date/Time field to your
table, and write an Update query that updates the new Date/Time field to
CDate(Format([TextField], "0000/00/00"))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Access Newbie looking for help"
< AccessNewbielookingf
orhelp@discussions.microsoft.com> wrote in message
news:88B0D22C-9332-423E-8169- 9E0F79402923@microso
ft.com...
>I imported data that is in Year Month Day format and saved this data as a
> table.
>
> How can I change this format to Month / Year format.

Sponsored Links