Specifying a range of dates

#1

I am trying to specify a range of dates in a query. I have tried using
Between "12/01/1938" and 05/31/1939", but I don't get any response. There
are dates in the table which should be showing in the query. I have also
tried to get a date by >= 12/01/1938 which does return valid dates.

Is there some date function that I should be using or am I just using the
wrong syntax? Any help would be most appreciated.

Thanks,

John

#2

You need a set of quotes before each date: Between "12/01/1938" and
"05/31/1939"

Jack
"jca1492" <jca1492 (AT) insightbb (DOT) com> wrote

Quote:

I am trying to specify a range of dates in a query. I have tried using
Between "12/01/1938" and 05/31/1939", but I don't get any response. There
are dates in the table which should be showing in the query. I have also
tried to get a date by >= 12/01/1938 which does return valid dates.

Is there some date function that I should be using or am I just using the
wrong syntax? Any help would be most appreciated.

Thanks,

John

#3

try DateDiff() or "Where (myDate < StartDate) AND (myDate < EndDate)"
in your coditions.

regards,

John
jobrien at acscience dot com

"jca1492" <jca1492 (AT) insightbb (DOT) com> wrote

Quote:

I am trying to specify a range of dates in a query. I have tried using
Between "12/01/1938" and 05/31/1939", but I don't get any response. There
are dates in the table which should be showing in the query. I have also
tried to get a date by >= 12/01/1938 which does return valid dates.

Is there some date function that I should be using or am I just using the
wrong syntax? Any help would be most appreciated.

Thanks,

John

#4

Dates in Access require a # delimiter.

Between #12/01/1938# and #05/31/1939#

should work.

Regards,
Mike Parks

"jca1492" <jca1492 (AT) insightbb (DOT) com> wrote

Quote:

I am trying to specify a range of dates in a query. I have tried using
Between "12/01/1938" and 05/31/1939", but I don't get any response. There
are dates in the table which should be showing in the query. I have also
tried to get a date by >= 12/01/1938 which does return valid dates.

Is there some date function that I should be using or am I just using the
wrong syntax? Any help would be most appreciated.

Thanks,

John

#5

Thanks for your help.

"John" <jobrienct (AT) excite (DOT) com> wrote

Quote:

try DateDiff() or "Where (myDate < StartDate) AND (myDate < EndDate)"
in your coditions.

regards,

John
jobrien at acscience dot com

"jca1492" <jca1492 (AT) insightbb (DOT) com> wrote

I am trying to specify a range of dates in a query. I have tried using
Between "12/01/1938" and 05/31/1939", but I don't get any response.
There
are dates in the table which should be showing in the query. I have
also
tried to get a date by >= 12/01/1938 which does return valid dates.

Is there some date function that I should be using or am I just using
the
wrong syntax? Any help would be most appreciated.

Thanks,

John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Specifying a range of dates

comp.database.ms-access comp.database.ms-access

Specifying a range of dates - 11-05-2003 , 02:53 PM

Re: Specifying a range of dates - 11-05-2003 , 08:46 PM

Re: Specifying a range of dates - 11-05-2003 , 09:07 PM

Re: Specifying a range of dates - 11-06-2003 , 10:22 PM

Re: Specifying a range of dates - 11-07-2003 , 10:25 AM