Query - date format

[Guest]

I am trying to pull date within 1 year.
What format should i use in my query.

 

[Guest]

GGill,

In the Criteria row of your date field, enter:

=DateAdd("q",-4,Date())

Sprinks

 

[John Vinson]

I am trying to pull date within 1 year.
What format should i use in my query.

Within...
one specific named year?
the past year, from a year ago today to today?
the forthcoming year, from today through a year from today?

If you mean within the past year, use a criterion on your date field
of

BETWEEN DateAdd("yyyy",-1,Date()) AND Date()

John W. Vinson[MVP]

 

[Guest]

for example:

From current date "9/27/2006"
So it should pull all data between "9/27/2006" and "9/27/2005"

Thanks

 

[John Vinson]

for example:

From current date "9/27/2006"
So it should pull all data between "9/27/2006" and "9/27/2005"

Like I said:

BETWEEN DateAdd("yyyy",-1,Date()) AND Date()


John W. Vinson[MVP]

 

[Guest]

Thank you so much it's working great.

Like I said:

BETWEEN DateAdd("yyyy",-1,Date()) AND Date()


John W. Vinson[MVP]