Between 2 dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbie - 30 Nov 2007 17:10 GMT

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'))

Reply to this Message

mscertified - 30 Nov 2007 17:41 GMT

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

> 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'))

Reply to this Message

John Spencer - 30 Nov 2007 17:46 GMT

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#

Signature

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

Reply to this Message