Report -data from date user enters in prompt to 1 year out

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

Guest

I need to modify a report to list data from a date entered through the next
year of the date entered.
 
I need to modify a report to list data from a date entered through the next
year of the date entered.

One year from the current date?
As criteria on the Date field:
Between Date() and DateAdd("yyyy",1,Date())

One year from a date entered in a query prompt?
Between [What Date?] and DateAdd("yyyy",1,[What Date?])

One year from each record's date?
Between [DateFieldName] and DateAdd("yyyy",1,[DateFieldName])
 
One year from a date entered in a query prompt.

Thanks

fredg said:
I need to modify a report to list data from a date entered through the next
year of the date entered.

One year from the current date?
As criteria on the Date field:
Between Date() and DateAdd("yyyy",1,Date())

One year from a date entered in a query prompt?
Between [What Date?] and DateAdd("yyyy",1,[What Date?])

One year from each record's date?
Between [DateFieldName] and DateAdd("yyyy",1,[DateFieldName])
 

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

Back
Top