I am working on a report that returns records for a certain date range. I have a Parameter named pEndDate. I put together the following formula.
Date(Year({@pDateEnd}-1),Month({@pDateEnd}),Day({@pDateEnd}))
When I give the report a parameter value of "2010-03-21"
The formula reads 3/21/2010
I want it to read 3/21/2009 (the current year minus one).
How do I do that?
Thanks in advance.