BD Access, Data field

Asked

Viewed 75 times

0

In an Access BD with a "Data" field, when entering data in this field, is it possible to do something so that dates passed 3 days ago are rejected? If possible, please teach me! In fact, I only managed to ensure that future dates are not inserted, through the following expression in the property "Validation rule": <=Data(). It is that the data are collected, daily, through Outlook form and some send with very old date. Thank you!

database validation insert ms-access

  • Have you ever tried to develop something? They will hardly give you something ready. Try to show what you have tried

  • Ok, actually I only managed to get future dates not to be inserted, through the following expression in the property "Validation rule": <=Data(). It is that the data are collected, daily, through Outlook form and some send with very old date. Thank you!

  • add your attempt into the question body, try (Date()) <= (Date() - 3)

  • correction (Date()) >= (Date() - 3)

  • Thanks friend @Hebertdelima de Lima, I tried your suggestion, did not work but, I confess that helped me a lot because, allowed me to think and try the expression '>=Data()-3', with which the BD prevents the old dates intended but unfortunately accepts future dates (least). So I fight harder, although I feel very satisfied, thank you!

  • do you want the maximum date to be the current day, and the old date at most 3 days? your condition would be hoje >=Date()-3 e hoje <= Date()?

  • Thanks, dear @Hebertdelima you helped me a lot, I’m happy, thank you! But, it must be said that the condition with the words "today" did not help, I tried to eliminate and it worked, I mean, I used the following:>=Date()-3 E <=Date().

  • Blessed hour that I found this space with wonderful people with Mr. @Hebertdelima, I am sure that I will learn a lot and little by little by realizing my dream of understanding Programming, although, unfortunately for the moment, I have very little to contribute, because I am still at level 0 or 1/1000 (rs). Thank you, I count on you for other questions and may the Lord bless us!

Show 3 more comments

1 answer

0


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

  • Thank you dear @Hebertdelima, congratulations and hope for more of your contributions in the other question I submitted. Good morning!

Browser other questions tagged database validation insert ms-access

You are not signed in. Login or sign up in order to post.