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.
Click to expand...

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.
Click to expand...

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])
Click to expand...
 
Back
Top