Date that falls between 2 other dates

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?
 
A

akphidelt

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#
 
I

Ivan Grozney

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
 
Top