Date that falls between 2 other dates

  • Thread starter Thread starter Txlonghorn76
  • Start date Start date
T

Txlonghorn76

I have a query which includes an Invoice date field and I want only the
invoice dates that fall between the Start Date Field and the End Date field.
How can I tell the query to select all invoice dates that are greater than
the Sate Date field and less than the End date field?
 
In the Invoice Date criteria put in

Between [Start Date Field] And [End Date Field]

If you are manually plugging in the date values then use # signs like

Between #1/1/2008# And #12/31/2008#
 
Are StartDate and EndDate values from a form or are you going to hard code
these in?

If from a form:
Between forms!_your form name here_!StartDate AND forms!_your form name
here_!EndDate

< forms_your form name here_EndDate AND > forms!_your form name
here_!StartDate

Hard Coded
Between #1/1/2003# AND #2/2/2009#
#1/1/2003# AND <#2/2/2009#
Click to expand...

HTH

Vanya
 
Back
Top