A saleman wants to be able to compare any random date range of this fiscal year with the same date range of last year.  I made two parameters 1. Start Date this year, 2. End Date this year.  I want to write a formula that will use those parameters and automatically chose the same date range of the pervious year.  This is what I have:  {BOKHST_LINE.DATE_TRX} IN DATE ({?STARTING DATE}) TO DATE ({?ENDING DATE}) OR {BOKHST_LINE.DATE_TRX} IN DATETIMEVALUE (({?STARTING DATE}) -1) TO DATETIMEVALUE (({?ENDING DATE}) -1)
The first part works but I get no data for the previous year????  I know the formula is wrong  but don't know what to do???