Skip to Content
0
Former Member
Mar 25, 2010 at 10:11 PM

Previous Year to Date formula

107 Views

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.