Issue in set analysis

[#1]

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

[sinanozdemir]

Try the below since you want to exclude all dates before 05/01/2015:

({$<[Transaction Invoice Date] = {">='05/01/2015'"}

[settu_periasamy]

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')

[jagan]

Hi,

Try like this

({$<[Transaction Invoice Date] = {">=$('05/01/15')"},

OR

({$<[Transaction Invoice Date] = {">=$(=Date('05/01/15'))"},

Regards,

Jagan.