Date format in VBA to SQLserver

S

Scamps

Can anyone help me with this brain teaser.

I have an Access Solution in which one of the reports has
a date passed to the ServerFilter property of the report
in order to filter the displayed records.

In VBA the ServerFilter Property is set as:
MyChosenDate='01/28/2004'

This works just fine on my machine but on another machine
in the office the same procedure in the identical client
produces a data overflow error. I found eventually the
cause of it was passing the date string in american
format. On this machine If I amend the date format to
englishUK format it works fine
i.e. MychosenDate='28/01/2004'

We are in the UK. Both machines have the same regional
settings and VBA has the same references loaded. I can
think of anything else that would cause an error on one
machine yet not on the other.

Both machines are on the same network and are connected
to the same SQL database.

Helpppppp
 
K

Keith Emery

I have had this issue as well. After extensive research, I
found that VBA only supports the US date format for SQL
commands.

Cheers Bill............
 
D

Douglas J. Steele

Not really. In addition to mm/dd/yyyy, VBA will support any unambiguous
format, such as yyyy-mm-dd or dd mmm yyyy.
 
?

???

Scamps said:
Can anyone help me with this brain teaser.

I have an Access Solution in which one of the reports has
a date passed to the ServerFilter property of the report
in order to filter the displayed records.

In VBA the ServerFilter Property is set as:
MyChosenDate='01/28/2004'

This works just fine on my machine but on another machine
in the office the same procedure in the identical client
produces a data overflow error. I found eventually the
cause of it was passing the date string in american
format. On this machine If I amend the date format to
englishUK format it works fine
i.e. MychosenDate='28/01/2004'

We are in the UK. Both machines have the same regional
settings and VBA has the same references loaded. I can
think of anything else that would cause an error on one
machine yet not on the other.

Both machines are on the same network and are connected
to the same SQL database.

Helpppppp
Click to expand...
 
Top