User input but one year earlier

[jhaynes]

Hello,
Is there a way I can ask the user for input such as below, and perform subtraction on a specific value, precisely the year?



I am currently entering a date range to run a query with the following command:

Between [Enter start date (yyyy-mm-dd)] And [Enter end date (yyyy-mm-dd)]

This works as it is supposed to. The problem is I need this value, but in a subreport I need the previous year. So if the user types 2011-01-01 and 2011-02-04. I need to modify this as 2010-01-01 and 2010-02-04. Likewise I would need to go back 25 years for the same period.

[pbaldy]

Well, you can add a field to your query, like:

StartDate: [Enter start date (yyyy-mm-dd)]

which will put the date in the results. Most of us use forms to gather user input, as you have more control. If you did that, you'd have it available for anywhere.

[jhaynes]

A form would be extra work, as all the report requires is the date, which works. I get the correct information using Between [Enter start date (yyyy-mm-dd)] And [Enter end date (yyyy-mm-dd)]
which then passes the information to a subreport. The subreport calls a seperate query which requires yyyy-1-mm-dd where the year is one less.

[pbaldy]

Having more control and flexibility is typically more work to set up, but it pays off in the long run.