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.