How do you setup a report so that the user can type in the to and from date range of the records they wish to view in a schedule?

  • 1
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have project activities scheduled and need to setup a report to pull records based on user inputted dates. Example: Report all scheduled activity from 11/14/2015 to 12/14/2015? How can you set it up so you can input the to and from dates?

 

Photo of Frank

Frank

  • 0 Points

Posted 4 years ago

  • 1
  • 1
No problem.

Just add a filter to the report which says

where all of the following

where [date] is on or after the date <ask the user>


where [date is on or before the date <ask the user>

The <ask the user should come up as a choice, or you can type that in exactly in that format.



The other option is to show the date field as one of the fields to be used as a dynamic Filter for the report.