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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Converting Date Format in an Access Table
When I looked at DougP's fix, inserting the "yy" in the year format, I thought "that's it!"<br> However, when I run the query it returns "05" as the "yy" for every entry, regardless of the actual date. The month and day comes out perfectly, but I don't...- jeffy
- Post #8
- Forum: Microsoft: Access Other topics
-
Converting Date Format in an Access Table
Elizabeth: Your function successfully returns a data type:text, but in the<br> format yyyymmdd. I need the date to be yymmdd. We're very close here - perhaps<br> you can give me the final clue. Thanks.- jeffy
- Post #6
- Forum: Microsoft: Access Other topics
-
Converting Date Format in an Access Table
Thanks for the reply!<br> I can go either way with this - would like to understand both, but will be happy to get one working.<br> One table has dates as data type:text, as 990601.<br> The other table has dates as data type:date/time, as 6/1/99 (note:not 06/01/99).<br> I need to convert the...- jeffy
- Post #3
- Forum: Microsoft: Access Other topics
-
Converting Date Format in an Access Table
I have imported data from Oracle, into an Access Table.<br> I need to export the data out of Access, into another database file format (Foxpro).<br> The problem is with the "date" field. It is data type: date, and the format is m/d/yy.<br> Ideally I would like to convert the dates to...- jeffy
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
