M
Maurice
Hope anyone can point me in the right direction here or to some KB explaining
how to fix this.
I've created a SQL-string in VBA which runs perfect. It consists of a couple
of parameters which are all supplied. This SQL statement is the recordsource
for my report. So far so good.
The SQL statement uses (among others) two variables entered through a
textbox on a form. These are Date values. I concatenate the variables to the
SQL-staement and the output in the immediatewindow shows exactly what it
should be.
Here's the problem. My reports are being filtered on the wrong dates.
Somehow the dates are being interpreted as US dates while they should be
European date formats.
To check the outcome i created a querydef which turns the variables around.
So 05-04-2007(EU) becomes 04-05-2007(US) format.
My Regional settings in Windows are set to Dutch (using a US keyboard
layout). All the other settings are set to Dutch.
Why is the output changed to US?
Sorry for the long post but I hope it makes any sense. Any ideas or
pinpointers greatly appreciated..
Maurice
how to fix this.
I've created a SQL-string in VBA which runs perfect. It consists of a couple
of parameters which are all supplied. This SQL statement is the recordsource
for my report. So far so good.
The SQL statement uses (among others) two variables entered through a
textbox on a form. These are Date values. I concatenate the variables to the
SQL-staement and the output in the immediatewindow shows exactly what it
should be.
Here's the problem. My reports are being filtered on the wrong dates.
Somehow the dates are being interpreted as US dates while they should be
European date formats.
To check the outcome i created a querydef which turns the variables around.
So 05-04-2007(EU) becomes 04-05-2007(US) format.
My Regional settings in Windows are set to Dutch (using a US keyboard
layout). All the other settings are set to Dutch.
Why is the output changed to US?
Sorry for the long post but I hope it makes any sense. Any ideas or
pinpointers greatly appreciated..
Maurice