Date validation

[kenseye]

I have two date fields Range1 and Range2 that define a date range. How do I validate that a third date field falls between Range1 and Range2 with the options/validation in Define Fields?

[kcat]

ThirdDate as a date field validated by calculation.

(ThirdDate >= Range1) and (ThirdDate <= Range2)

---

The only problem exists if you enter a value into ThirdDate before you set values in the Range1 and Range2 fields.

Check off 'Strict' and show a custom message if you wanna be Taliban about it.

-kc.