Exception for Data Validation Rule

Hi Heather, you can add the exception by taking advantage of the fact that record ID#s are generated when a new record is saved, but not before that time. So when you first add a record, before saving, Record ID# is blank. But if you come back later and edit the record, then Record ID# has a value. So you can tweak your custom data rule to check whether record ID# is null, to add the exception you're looking for:

If([Rate Effective Date]=[Service - Maximum Effective Date] and IsNull([Record ID#]) = true, "Can only have one price increase scheduled per day")

------------------------------
Brian Cafferelli
------------------------------