[AccessD] Dates As Criteria

Hi Mark

Show us your query, the SQL.
It probably has to do with a missing US format of the date values.

/gustav

>>> markamatte at hotmail.com 13-02-07 22:22 >>>
Hello All,

In A2K I ahve a form that has 2 unbound date fields...have input masks and 
formats as SHORT DATE...I have a query that uses these fields as criteria in 
a BETWEEN statement.  The field in the table is a general date.  I'm using 2 
records to check...if I set the startdate and enddate on the form to the 
dates that are in the db...they return..but if I use ofther dates...nothing 
comes back.  Example:

StartDate:2/6/2007
EndDate: 2/13/2007

2 records:
DT=2/9/2007
DT=2/13/2007

Using the above "between startdate and enddate" I return 1 record?
If I change the startdate to 2/9/2007 then I return both
IF I use 2/6 and2/17 as the start and end...I return NOTHING...

Anyone...please help...I'm sure I've done something silly...but this just 
doesn't make sense???

Thanks,

Mark A. Matte