20030101 to 01/01/2003

[priac]

How do I change a text date"20030101" to be a date "01/01/2003"

 

[psemianonymous]

You may not know this, but there is an option in MS Access to directly import YYYYMMDD dates to a Date/Time value. Go to advanced import options, set the order to YYYYMMDD, and delete the delimiter. I think that does it.


Otherwise left([field],4) gets the year,
mid([field],5,2) gets the month, and
right([field],2) gets the day.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[koresnordic]

You can create a query with the following as a selected field: "date:Right([issuedate],2)+"/"+Mid([issuedate],5,2)+"/"+Left([issuedate],4)" - where [issuedate] is the date you want converted. this will turn yyyymmdd into dd/mm/yyyy and make it fit into a date field (without the '/' charecters it assumes it is a number which it then converts into a date).



Graham