A
Aurora
I am using Access 2003
I created a preventative maintenance (pm) database that requires the
operator to enter the date when a pm operation is completed. The operators
doing this are not typist and I am finding a lot of error with date data
entry. Such as reversing month and day or putting in the wrong year. For
example: when the date should have been 2/4/08 - the employee is typing
4/2/08 or putting in the wrong year.
This date is an important field as future operations are keyed off of this
date. I want to make the date field limited to "NO date that is greater then
today" or has to be "within 1 month prior to today". Can any one suggest how
I could write a formula that could limit the date field in this way or at
least point to an web page that would be able to help me? I would appreciate
any help I can get.
Thank you - aurora
I created a preventative maintenance (pm) database that requires the
operator to enter the date when a pm operation is completed. The operators
doing this are not typist and I am finding a lot of error with date data
entry. Such as reversing month and day or putting in the wrong year. For
example: when the date should have been 2/4/08 - the employee is typing
4/2/08 or putting in the wrong year.
This date is an important field as future operations are keyed off of this
date. I want to make the date field limited to "NO date that is greater then
today" or has to be "within 1 month prior to today". Can any one suggest how
I could write a formula that could limit the date field in this way or at
least point to an web page that would be able to help me? I would appreciate
any help I can get.
Thank you - aurora