Validation Rule

[Tausif]

Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried

[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use multiple

columns at column level CHECK constraint.

How to define such validation rule?

Tausif

 

[Tausif]

Try to create Validation rule at table level but not at the field level. Use
following as reference.

http://www.kbalertz.com/209106/Table.Field.Validation.Causes.Error.aspx
Tausif.

Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried

[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use

multiple
columns at column level CHECK constraint.

How to define such validation rule?

Tausif