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

Quick date format converting Access 2007 to 2000

P: 10
Hi,

Quick one for you, i'm importing a file which has a long date and time format, so once imported i update each date field with the correct format (dd/mm/yyyy).

I wrote this in on click of a button in Access 2007 which works great:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL ("UPDATE " & tName & " SET [Reported Date] = Format([Reported Date],'dd/mm/yyyy'), [Resolved] = Format([Resolved],'dd/mm/yyyy');")
However i run it in Access 2000 and it converts to American style mm/dd/yyyy!?

Any ideas?

Thanks,

Chris
Mar 10 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Hi,

Quick one for you, i'm importing a file which has a long date and time format, so once imported i update each date field with the correct format (dd/mm/yyyy).

I wrote this in on click of a button in Access 2007 which works great:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL ("UPDATE " & tName & " SET [Reported Date] = Format([Reported Date],'dd/mm/yyyy'), [Resolved] = Format([Resolved],'dd/mm/yyyy');")
However i run it in Access 2000 and it converts to American style mm/dd/yyyy!?

Any ideas?

Thanks,

Chris
The reason Chris, maybe because you're regional settings may be set to American Style instead of Europian Settings, Check that out and see if that helps?

Joe P.
Mar 21 '08 #2

Post your reply

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