6 Replies Latest reply on Nov 25, 2008 9:54 AM by raybaudi

    Field Validation by calculation



      Field Validation by calculation


      I am trying to use the following calc to validate the taxcode for an invoice lineitem and am using  the following in field validation but it will not work.


      If (InvoiceHeader::InvoiceDate < 01/12/2008 and TaxCode =  "T1" ;1 ; 0 )


      The idea is that if the invoice date (related table DD/MM/YYYY) is less than Dec 1st and the taxcode for this lineitem = T1 then the taxcode is valid, but it keeps giving me the invalid response.


      Any help appreciated.