By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,491 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 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+
1 Reply

Expert Mod 10K+
P: 14,534
Hi Daniel

Set the format in the field of the table to "yyyy-mm-dd" and when using the sql to append ensure it by using Format([FieldName],"yyyy-mm-dd")

Mar 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.