Query dates less than a year old.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My query has a column of dates (m/d/yyyy) over the past few years. I want to
query all dates equal to or less than one year ago. What should I use as the
criteria?

Thanks in advance.

Emily
 
Hi, Emily Sue.
What should I use as the
criteria?
Click to expand...

To display all records equal to or less than year old, you could use syntax
such as the following in your query:

SELECT *
FROM MyTable
WHERE ((DateDiff("yyyy", ChkDate, Date()) + Int(Format(Date(), "mmdd") <
Format(ChkDate, "mmdd"))) <= 1);

.... where ChkDate is the name of the column with dates and MyTable is the
name of the table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Emily said:
My query has a column of dates (m/d/yyyy) over the past few years. I
want to query all dates equal to or less than one year ago. What
should I use as the criteria?

Thanks in advance.

Emily
Click to expand...

WHERE DateFieldName <=DateAdd("yyyy", -1, Date())
 
Back
Top