I need help on a view filter. I tried it via view UI setting but does not work.  Then I am working in designer with the following code. I got an error when I open it in browser Cannot complete this action. Please try again.. I appreciate if someone can help me out on the query. Many thanks.

If in code, the condition should be

(OutstandinginvoiceTotal > 0) &&

   (

       (Today() - InvoiceDate > 60 && Today() InvoiceDate < 30) ||    

       (Today() - InvoiceDate_2 > 60 && Today() InvoiceDate_2 < 30)

   )    

Here is the view filter

<Query><Where>

    <And>

         <Gt><FieldRef Name="OutstandingInvoiceTotal"/><Value Type="Currency">0</Value></Gt>

         <And>

              <Geq><FieldRef Name="InvoiceDate"/><Value Type="DateTime"><Today OffsetDays="-60"/></Value></Geq>

              <And>

                 <Lt><FieldRef Name="InvoiceDate"/><Value Type="DateTime"><Today OffsetDays="-30"/></Value></Lt>

              </And>

         </And> 

         <Or>

              <And>

                 <Geq><FieldRef Name="InvoiceDate_2"/><Value Type="DateTime"><Today OffsetDays="-60"/></Value></Geq>

                 <And>

                    <Lt><FieldRef Name="InvoiceDate_2"/><Value Type="DateTime"><Today OffsetDays="-30"/></Value></Lt>

                 </And>

              </And>

         </Or>      

    </And>

</Where></Query>

• Edited by eg10013 Friday, April 17, 2015 1:42 PM

Here is my working solution:

• Edited by eg10013 Friday, April 17, 2015 7:32 PM
• Marked as answer by eg10013 Friday, April 17, 2015 7:32 PM