AnsweredAssumed Answered

Field Validation by calculation

Question asked by ceebee on Nov 25, 2008
Latest reply on Nov 25, 2008 by raybaudi


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.