Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date conversion
- Thread starter Luhrern
- Start date
As the 20020726 format is not a recognised date format in Access, you will need to parse it into a date, e.g.
MyDate=DateSerial(left(text1,4), mid(text1,5,2), mid(text1,7,2))
This will put the date into a date variable (if MyDate is set up as a date variable). You can then set the format of any output to yyy\.mm\.dd to show it the way you want. Have fun!
)
Alex Middleton
MyDate=DateSerial(left(text1,4), mid(text1,5,2), mid(text1,7,2))
This will put the date into a date variable (if MyDate is set up as a date variable). You can then set the format of any output to yyy\.mm\.dd to show it the way you want. Have fun!
)Alex Middleton
- Status
Similar threads
- Question
