Skip to Content
0

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

Jan 19, 2017 at 10:00 PM

19

avatar image
Former Member

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;

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Jan 20, 2017 at 07:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded