G
Guest
I am trying to pull date within 1 year.
What format should i use in my query.
What format should i use in my query.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
GGill,
In the Criteria row of your date field, enter:
Sprinks
In the Criteria row of your date field, enter:
=DateAdd("q",-4,Date())
Sprinks
J
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]
G
Guest
for example:
From current date "9/27/2006"
So it should pull all data between "9/27/2006" and "9/27/2005"
Thanks
From current date "9/27/2006"
So it should pull all data between "9/27/2006" and "9/27/2005"
Thanks
J
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]
G
Guest
Thank you so much it's working great.
John Vinson said:Like I said:
BETWEEN DateAdd("yyyy",-1,Date()) AND Date()
John W. Vinson[MVP]