Weird Access Date Validation Problem

Conanius · 27 Apr 2006 at 11:22

All,

trying to sort an access database which I need to only accept date set from now to 3 years in the future. (it can not be over 3 years in advance)

What validation code should I be using for this?

Conanius · 27 Apr 2006 at 21:46

Fezzer said:
The simple answer is

Code:

Between Date() And DateAdd("yyyy",3,Date())

Although you might come across issues if you use this as a validation rule for a field in a table.

ok,

We need it to be used in a table for people booking the use of something, and the dates obv can only be Today or up to 3 years in the future, so with this scenario, where are we going wrong?

Conanius · 29 Apr 2006 at 21:26

Ive spoken to a few people, and the data wouldnt be edited after it had been entered (data will be entered through a form info the table I believe)

does that help?

Conanius · 3 May 2006 at 23:07

no one?