Help with date filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following date filter in a column on my query. The problem I
have is that it is including dates i do not want to see. For example If
DStart2 = 1/3/07 and DEnd2 = 1/4/07 then it will return all records for
1/3/07 and 1/4/07 but will also return records for 1/30/07 and 1/31/07. Any
help?
 
Is your field a true DateTime datatype field or a text field? It seems like
the action is as if it is a text fields that you have loaded what appears to
be dates.
--
KARL DEWEY
Build a little - Test a little


Qaspec said:
I am using the following date filter in a column on my query. The problem I
have is that it is including dates i do not want to see. For example If
DStart2 = 1/3/07 and DEnd2 = 1/4/07 then it will return all records for
1/3/07 and 1/4/07 but will also return records for 1/30/07 and 1/31/07. Any
help?
([Forms]![MainForm]![DStart2]) And <([forms]![MainForm]![DEnd2]+1)
Click to expand...
Click to expand...
 
Back
Top