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

Expand Post »

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

Similar Threads

date problem in Visual Basic 4 / 5 / 6
Dreamweaver MX2004 & date problem, etc. in Graphics and Multimedia
Microsoft Access date validation Need a solution in Computer Science
Microsoft Access date validation Need a solution in Database Design
Access Date Problem in Computer Science

mrnath

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Nov 2005

Permalink

Nov 14th, 2005

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!

mrnath

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Nov 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Computer Science Forum Timeline: Connect 4 AI Agent

Next Thread in Computer Science Forum Timeline: Best languages to learn.

DaniWeb Message

Cancel Changes

User Name
Password