Skip to Content

Iam trying to filter data by day and month but not year.

I am trying to get data by day and month of datefield column.

I Tried this below but giving error:

IF {USR_MBR_RenewalStatistics_SP;1.OriginalLineStatusCode} = "A" AND {USR_MBR_RenewalStatistics_SP;1.OrigialInvoiceDate} <= Month(({?@Invoicedate})) AND {USR_MBR_RenewalStatistics_SP;1.OrigialInvoiceDate} <= Day(({?@Invoicedate})) THEN 1 ELSE 0;

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 20, 2017 at 07:28 AM

    Hi Faiyaz,

    Try:

    IF {USR_MBR_RenewalStatistics_SP;1.OriginalLineStatusCode} = "A" AND
    Month({USR_MBR_RenewalStatistics_SP;1.OrigialInvoiceDate}) <= Month(({?@Invoicedate})) AND 
    Day({USR_MBR_RenewalStatistics_SP;1.OrigialInvoiceDate}) <= Day(({?@Invoicedate})) THEN 1 ELSE 0;

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded