AnsweredAssumed Answered

Field Validation by calculation

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

Title

Field Validation by calculation

Post

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.

Ceebee

Outcomes