Hi Access Date Problem (> Now +7 Days And < Now +2 Months)
 

Im currently using Access 2000 when at home and Access 2002 when at college.

I want to create a date validation that allows only dates

> Now +7 Days And < Now +2 Months

At the current moment i have.

>(Int(Now()))+7 Which will only allow date entrys to be entered if they are 1 week from today. But im having trouble with the 2 month part. I want it to be more accurate than 62 days i want it in months.

Currently neither access have EDATE function. All and Any help is welcome.. Thanks

Nathan

Re: Hi Access Date Problem (> Now +7 Days And < Now +2 Months)
 

Ok, a very kind person helped me with this already :) you know who you are and thanks :)

If you are also suffering the same type of problem.

DateAdd ("m",2,int(now())) you can substitute M for Weeks, Hours, Minutes, Years, Months.. GL!