6 Replies Latest reply on Dec 21, 2015 7:23 AM by binu.alexander

    Is this Date Range Expression Valid ?

    binu.alexander

      Date ( 4 ; 1 ; Year ( PaymentInvoiceRecord::DatePaid ) )&"..."&Date ( 3 ; 31 ; Year ( PaymentInvoiceRecord::DatePaid )+1 )

       

      eg.  betwen April 1st 2015 and March 31st 2016    when     PaymentInvoiceRecord::DatePaid =  20/12/2015

       

      This is an attempt to enter a date range in a scripted find ..

       

      Debuggger shows invalid input in Find Mode ...

       

       

      I tried to  do a  console print of the expression  ( i.e through the Show Custom Dialog )   it shows   "? ... ?"

       

      Can anyone please help me get the correct expression ?