Hi,

( I have my ADSL break for 2 days ... )

I am working/learning ASP.NET, C# and use my DBC and DBF for data containers.

Yes, this is filter and the wright answer is:

< % @Import Namespace = "System.Globalization" % >

CultureInfo usCulture = new CultuireInfo("en-us")

cmd.CommandText =
string.Format(usCulture,"SELECT * from .... WHERE EventDate >=#{0:d}# and ... <= #{1:d}#)

This way any data format is allways corect interpret as MM/dd/yyyy !.

But, in fact my original Q., beside this main problem had another component ...

How sholud I write above statement but not using String.Format(). Only SELECT ... and
what is required ?

Regards, Gojko