Yo,
I dont think this is a toughy, but i dont know how to do it.
I am trying to be able to automatically genertae dates in a table. there are 2 fields that i need to generate.
The first is the date when the record is made (todays date basically) which is easy (=now()), BUT i want the other field to be the days date PLUS 3 years. These need to be stored in the table as there are other fields too (but dont require calculations).
Cheers guys
I dont think this is a toughy, but i dont know how to do it.
I am trying to be able to automatically genertae dates in a table. there are 2 fields that i need to generate.
The first is the date when the record is made (todays date basically) which is easy (=now()), BUT i want the other field to be the days date PLUS 3 years. These need to be stored in the table as there are other fields too (but dont require calculations).
Cheers guys
