471,086 Members | 1,137 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

Quick date format converting Access 2007 to 2000

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
1 1736
PianoMan64
374 Expert 256MB
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.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.