Crystal reports - Previous year  but same date range

kelsanit used Ask the Experts™
have crystal report where i am passing startdate and enddate to sub report.  In the sub report I have two running totals:

1: Requested Period sales:  uses startdate and enddate of values passed to sub report
2: Previous Period Sales:  want to use same date range but change year -1  

what is the best way to do this?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
I assume you are filtering based on the date

You can get last year with

DateAdd('yyyy',-1, {YourStartDate})

DateAdd('yyyy',-1, {YourEndDate})


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial