Hello
Just wondering if there's a way to do this:
field 1 - manually fill in a date
feild 2 - refers to field one, subtracts a year and then automatically fills in that date.
I have a databased that manages 400 records that are leases/legal agreements - and field 1 is the expiry date of the agreement and feild 2 is the date we have to give notice to the leasee that the contract is going to expire
I know it might seem pedantic to have the field 2, but I have to run a BF report for an 18 month period to let other people know that they have to give notifications ahead of time.
So, the report I give them will have
lease # / client / expiry date / expiry notice