I'm using Crystal v9, pervasive sql.
I'm trying to get a formula to extract the transaction amounts that are in the same period as the start and end dates, but for the last year.
I set up two parameters:
{StartDate}
{EndDate}
I need the formula to figure what the date was last year of the {StartDate} and the date for last year of the {EndDate}.
My report shows the transactions amounts for the Current Period which is equal to transaction dates between and including the {StartDate} and {EndDate}.
It also needs to show the transaction amounts for the same period last year. This is where I'm lost.
I've tried: DateDiff({?Start Date}"mm"-12, "yyyy"-1)
But this returns an error "the ) is missing on the "mm" of the formula.
I'm trying to get a formula to extract the transaction amounts that are in the same period as the start and end dates, but for the last year.
I set up two parameters:
{StartDate}
{EndDate}
I need the formula to figure what the date was last year of the {StartDate} and the date for last year of the {EndDate}.
My report shows the transactions amounts for the Current Period which is equal to transaction dates between and including the {StartDate} and {EndDate}.
It also needs to show the transaction amounts for the same period last year. This is where I'm lost.
I've tried: DateDiff({?Start Date}"mm"-12, "yyyy"-1)
But this returns an error "the ) is missing on the "mm" of the formula.