I'm using an ODBC with Crystal X trying to get a "last month" suppression formula to work by using the dateadd formula
{AR_StatementWrk.TransactionDate}<= dateadd("M",-1,{@StatementDate to Date}).
What's happening is it's only suppressing detail up to the same day of last month. Example: If I run my report as of Dec 2 I still get detail for Nov 1. What I need it to suppress is detail for all prior months except the one I'm running it for.
Any help will be greatly appreaciated.
{AR_StatementWrk.TransactionDate}<= dateadd("M",-1,{@StatementDate to Date}).
What's happening is it's only suppressing detail up to the same day of last month. Example: If I run my report as of Dec 2 I still get detail for Nov 1. What I need it to suppress is detail for all prior months except the one I'm running it for.
Any help will be greatly appreaciated.