Date query

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

I only want a query to return records that are a year or
less than a year old
Thanks
 
Open your query in design mode. Type the following in the
criteria for your date field: >=DateAdd("yyyy",-1,Date())
This means that you want all rows where your date is
greater than or equal to last year(today's date minus 1
year).
 
-----Original Message-----
I only want a query to return records that are a year or
less than a year old
Thanks
.
Click to expand...
Use the > or < in front of the date that = the one year
mark.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating fiscal year for two dates in query 5
Return a date range based on today's date 6
First function returning min 4
Query Criteria 2
Query current fiscal year 2
multiple records from one 1
Query Parameters 1
Access Dcount function in access 0

Back
Top