mid(yymmdd,3,2) & "/" & right(yymmdd,2) & "/" & left(yymmdd,2)
hope i got my syntax right but that will get you moving along hopefully.
if you ant a true date i just tried something the other day for a
similar problem.
cdate(mid(yymmdd,3,2) & "/" & right(yymmdd,2) & "/" & left(yymmdd,2))
that will return an actual date type of data otherwise it will be text
I have data from a legacy system. The date is yymmdd. I would like to format
(display) this in a query or form as mm/dd/yy.
The data comes as a text field when I import it into Access from ASCII.
Can anyone help me?
Thanks
Matt
--
Charles E. Vopicka's (Chuck) : (e-mail address removed)
Database Management, GIS Specialist and Research Assistant
Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America
Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)
HAVE A NICE DAY (-:
"UNLESS" (The Lorax, by Dr. Seuss)