dates

[Guest]

I have a query that I would like to pull the previous 12 months and any dates
in the future. So if I had events that have occurred in the past 12 months
and then had 12 events that are yet to occur in the future, I would like to
include all of these events in my query. I would like this to reflect
today's date. So tomorrow, my results may be different. Thank you for your
time.

 

[fredg]

I have a query that I would like to pull the previous 12 months and any dates
in the future. So if I had events that have occurred in the past 12 months
and then had 12 events that are yet to occur in the future, I would like to
include all of these events in my query. I would like this to reflect
today's date. So tomorrow, my results may be different. Thank you for your
time.

As criteria in the Date field:

 

[John Vinson]

I have a query that I would like to pull the previous 12 months and any dates
in the future. So if I had events that have occurred in the past 12 months
and then had 12 events that are yet to occur in the future, I would like to
include all of these events in my query. I would like this to reflect
today's date. So tomorrow, my results may be different. Thank you for your
time.

Use a criterion of

= DateAdd("yyyy", -1, Date())

This will subtract a year from today's date and return all records
where the date field is later than that date.

John W. Vinson[MVP]