September 25, 200223 yr 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?
September 25, 200223 yr Newbies 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.
Create an account or sign in to comment