Between 2 dates

[Debbie]

I'm new to access, but have Oracle exprience. What is the syntax for the
where clause 'between date1 and date2'
In Oracle I would say date_column between
to_char(to_date('01/01/2007,'mm/dd/yyyy')) and
to_char(to_date('01/01/2007,'mm/dd/yyyy'))

 

[mscertified]

If you are talking about a date column, you can use
Date >= Date1 AND Date <= Date2 - OR-
Date between Date1 and Date2

If using literal dates use syntax #mm/dd/yy#

-Dorian

 

[John Spencer]

Between #2007-01-01# and #2007-01-01#

You could also use the format mm dd yyyy (US-Centric)

BETWEEN #1/1/2007# and #12/31/2007#

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..