help need for a query that looks a field date and tells if it is one year past

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

I need help! I am building a datebase that is used to
track training, with dates entered in a field. I want
query that will search a field and tell me if it greater
than 1 years past the current date. Can someone help me!
I know everything else except how to build a query like
this one.

Thanks much
Bobby
 
Bobby,

Here's one way... In your query, make a calculated field by typing the
equivalent of this in the Field row of a blank column in the query
design grid...
DateTest: DateAdd("yyyy",-1,[YourDateField])
.... and then in the criteria of this column, put...
Date()
Click to expand...
This will give you records where the date field is "more than one year
in the future", which is what I interpreted your question to mean.
However, if you mean where the date is "more than a year in the past",
than the expression would be...
DateTest: DateAdd("yyyy",1,[YourDateField])
.... and the criteria would be...
<Date()
 
I need help! I am building a datebase that is used to
track training, with dates entered in a field. I want
query that will search a field and tell me if it greater
than 1 years past the current date. Can someone help me!
I know everything else except how to build a query like
this one.
Click to expand...

Use a criterion of
DateAdd("yyyy", 1, Date())
Click to expand...

to get those values where the datefield is more than one year in the
future from today (I'm not sure what you mean by "1 years past the
current date").
 
Back
Top