A
angie
i have created a table including the following fields:
activation date and expiration date. i want to create a validation rule for
the expiration date that allows me to enter data relative to the activation
date.
e.g. if activation is 30/06/2005 the expiration should be one year later
30/06/2006, no other data should be entered.
can i achieve that when i create the table or do i have to create a query?
if yes which function should i use and how?
thank you in advance!
activation date and expiration date. i want to create a validation rule for
the expiration date that allows me to enter data relative to the activation
date.
e.g. if activation is 30/06/2005 the expiration should be one year later
30/06/2006, no other data should be entered.
can i achieve that when i create the table or do i have to create a query?
if yes which function should i use and how?
thank you in advance!