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

  • Thread starter Access Newbie looking for help
  • Start date
A

Access Newbie looking for help

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.
 
D

Douglas J. Steele

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

(no e-mails, please!)



"Access Newbie looking for help"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Creating a Search using a combo box and then creating a report. 4
Format change in merge data - Bold formatting after a comma 0
Excel does not accept text format! 0
Table of content - format does not get saved 2
How to have two tables on same line? 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Setting column width in a table with a macro is not working 0

Top