Quick date format converting Access 2007 to 2000

[BulbFresh]

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:

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

[PianoMan64]

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:

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.