By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,806 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,806 IT Pros & Developers. It's quick & easy.

Convert date in Access 2003

P: 8
Dear all,

hope to get lucky with you..

Have normal Access 2003 DB. It has a standard table with one column showing dates in DD.MM.YYYY format.

I hate that format and tries to convert it to standard: YYYY-MM-DD

I have used a SQL query that imports all posts without conditions to a new table, and then I have tried to use some SQL tricks to reformat the Column Date into the new format - but this doesnt really work for me.

Can you solve it with VBA?

Please impress me and give me some hints!

Mar 16 '07 #1
Share this Question
Share on Google+
2 Replies

P: 1
Visual Basic the command is- format(date-to-be-formated, "yyyy/MM/dd mm:ss tt" . That will take your string of "01/01/2001 12:00:15 PM" and convert it to "2001/01/01 12:00:15 PM".
Mar 19 '07 #2

P: 1,646
This has already been answered in another thread so I am closing this one.
Mar 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.