Hello,

Something is puzzeling me for some time.
In a form the filter property is set with VBA to something like:
me.filter = "[DateA] > #1-1-03# and [DateA] < #31-1-03#

The properties of the form show this string, so this should work OK.
The form however is not filtered right.
When I look at the "filter by form" screen it shows for field [DateA]:
As you may gather, I use the european format for dates.
What I don't understand is that de string is interpreted in a US way.
How can I convert the dates, or convince Acces of my view?

Appeciate your help
Adrian