AnsweredAssumed Answered

Is this Date Range Expression Valid ?

Question asked by binu.alexander on Dec 21, 2015
Latest reply on Dec 21, 2015 by 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 ?

Outcomes