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

    Field Validation by calculation

    ceebee

      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