okay i may not be able to explain this clearly.....i'm creating a vacation request form on a website and we're trying to make it so that the form can not be turned in unless the first day of your vacation is 14 days or more from todays date. we have a field that automatically fills in todays date. we're using DateDiff('d', submitdate, releasedate) < 14. but we've plugged in GETDATE() instead of submitdate. instead of release date i need something that will plug in the start date of their vacation, which is a field they fill in on the form using a calender. does anyone know how to do this? if you need more clarification just ask.
we're obviously using validation compare