Blacksh
asked on
Date field2 calculate 30 days after the date of date field1
Hello. I am using Microsoft Access 2000. I have two date fields in a form. Datefield1 is any date (usually today's date). I would like date field2 to calculate 30 days from date field1. I am using a form that is connected to a table.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much.
=DateAdd("d",-30,[txtNameO
However, at months' end - ultimo - you will probably obtain a better result by subtracting a month:
=DateAdd("m",-1,[txtNameOf
Further, field1 may be empty (Null), thus:
=IIf(IsNull([txtNameOfText
Of course, if "from field1" means "after field1" then remove the minus sign.
/gustav