Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please tell me what's wrong with the date.
({$<[Transaction Invoice Date] = {'>=$( =(05/01/15))'},
[Payoff Transaction Code]={'0001', '0002', '0003', '0004'},[Transaction Counter]={'*1*'},[PCRO]={'*1-1-60*'}>}
[Transaction Invoice Total Amount Billed] * FABS([SEC Funder Multiplier]))
I just want to exclude all amounts pertaining to transactions before 05/01/15. Just unable to put it in the set analysis expression. I only have problem with the date part, rest works fine.
Regards,
Sachin
Try the below since you want to exclude all dates before 05/01/2015:
({$<[Transaction Invoice Date] = {">='05/01/2015'"}
Hi,
if you have the date format like 05/01/15, try like this
({$<[Transaction Invoice Date] = {'>=05/01/15'}
if the Transaction Invoice Date is different, you need to convert using the date function.
Date('05/01/15','MM/DD/YYYY')
Hi,
Try like this
({$<[Transaction Invoice Date] = {">=$('05/01/15')"},
OR
({$<[Transaction Invoice Date] = {">=$(=Date('05/01/15'))"},
Regards,
Jagan.