I've been staring at this too long, and all my formulas are running together....
Any ideas why this formula is not giving me information within the date parameter? (Yes, I know my formula could be condensed).
I'm using 5/31/06 as my cut off date, and it is still giving me entries that are for June.
IF({CURRENT_JCT_TRANSACTION.Transaction_Type} = "Aprvd schdl val chng" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Scheduled value" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Pndng schd val chg 2"
and {CURRENT_JCT_TRANSACTION.Accounting_Date} <= {?Cut Off Date})
Then {CURRENT_JCT_TRANSACTION.Amount}
Thanks,
Holly
Any ideas why this formula is not giving me information within the date parameter? (Yes, I know my formula could be condensed).
I'm using 5/31/06 as my cut off date, and it is still giving me entries that are for June.
IF({CURRENT_JCT_TRANSACTION.Transaction_Type} = "Aprvd schdl val chng" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Scheduled value" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Pndng schd val chg 2"
and {CURRENT_JCT_TRANSACTION.Accounting_Date} <= {?Cut Off Date})
Then {CURRENT_JCT_TRANSACTION.Amount}
Thanks,
Holly