Hello I am using reort builder 1.0 . I am connecting to oracle database using a report model I would like to get data from the tables.. the condition in pl/sql looks like this how can we convert it into .. report builder.. functions or should i create query in report model itself and use it in report builder BETWEEN NEXT_DAY(sysdate-14,'SUNDAY') AND NEXT_DAY(sysdate-8,'SATURDAY') ) Thanks in advance..

Hi, By generally, we can use Filter in Report Builder to filter data. According to the expression you posted, I regarded it as 2 conditions below: · After or on the next Sunday of 14 days before today. · Before or on the next Saturday of 8 days before today. If I have misunderstood please point out. If not, please refer to the following steps : 1. Click Filter in the Tool Bar to open the Filter Data window. 2. Double click your date filed in the Fields pane to add a condition on it. 3. Right click the filed name which you added and select Edit As Formula. 4. In the Define Formula window, specify the formula to achieve the first condition like DATEONLY(YourDateField) >= DATEADD(DAY,-(6+DAYOFWEEK(TODAY())),TODAY()) 5. Click OK, and then repeat Step 2 to Step 4 to add the other condition by specify the formula like DATEONLY(YourDateField) <=DATEADD(DAY,(7-DAYOFWEEK(DATEADD(DAY,-8,TODAY()))),DATEADD(DAY,-8,TODAY())) Please also be aware to correct YourDateField in both formulas. For more information about Working with a Filter in Report Builder 1.0, please see: http://technet.microsoft.com/en-us/library/aa337164(v=SQL.90).aspx For more information about Working with Formulas in Report Builder 1.0, please see: http://technet.microsoft.com/en-us/library/aa337326(v=SQL.90).aspx Thanks, Tony Chain