BD Access, Data field

0

In an Access DB with a "Date" field, when entering data in this field, is it possible to do something so that dates that have been passed for another 3 days are rejected? If possible, please teach me! In fact, I was only able to prevent future dates from being inserted, by means of the following expression in the "Validation rule" property: < = Date (). Is that the data are collected daily through the form of Outlook and there are those who send with a very old date. Thanks!

    
asked by anonymous 09.07.2016 / 22:32

1 answer

0

To close the question:
>= Date()- 3 E <= Date()

    
12.07.2016 / 22:34