Need to compare dates

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

Comments

  • : 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
    Hi,
    Visit
    http://nirosoft.blogspot.com/
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion