Date Range for Query Filter

[david.isaacks@mail.va.gov]

I have a table with an [Open] as a field with the date/time in it.
Formated like "3/20/2006 7:25:00 AM"

I want to be able to create a query for just the dates in Feb, March,
April, etc.. I do want to retain the time. How can I query between
dates while keeping the time?

Dave

[david.isaacks@mail.va.gov]

Re: Date Range for Query Filter

I have tried this - >=[02/01/2006] And <[02/28/2006] but it keeps
asking for prompts. - David

[david.isaacks@mail.va.gov]

Re: Date Range for Query Filter

I figured it out. Dumb mistake.
[color=blue]
>=#2/1/2006# And <#3/1/2006#[/color]

David