InvoiceHeader::InvoiceDate < Date ( 12 ; 1 ; 2008 ) and TaxCode = "T1" ; 1
InvoiceHeader::InvoiceDate < Date ( 12 ; 1 ; 2008 ) and TaxCode = "T1"
Sorry Daniele that doesnt seem to work either :(
... but it has to work !
Into the validate option check "Always"
Thank you for your post.
This seems to work well for me. Are you sure that InvoiceDate is a Date field and TaxCode is a Text field? This would definitely cause a problem.
If I enter 30/11/2008 and T1, it works fine. I get the invalid message when I enter 1/12/2008 and any value, or any date less than 1/12/2008 and any value of TaxCode other than T1.
I have checked that InvoiceDate is a date field and TaxCode is a text field.
The form I am using is based on the InvoiceHeader table which is where the InvoiceDate comes from and the TaxCode is within a portal. Does it make a difference the TaxCode is the field being validated but is also being used in the calculated result?