Other Date Problem

[Smarty]

I have this filter in my sqlstatement:
"WHERE [Datetable].[Datefield] BETWEEN #3/01/01# AND #6/07/01#" (it is generated by code). The problem is that he won't display the record with a date f.e. 28/06/01. What am I doing wrong?

Thanx,

Maarten

 

[bosully]

Access sometimes interprets dates in the American format. That means it reads #3/01/01# as March 1st and #6/07/01# as June 7th. That's why June 28th is missing.

I have never really found a good foolprood way around this. I generally make my dates explicit, like #03/Jan/01#. This may work for you or it may only work for me because of date settings on the computer. Either way, givt it a try,

Brendan