Auto calculate date

[Guest]

Hi. This is my first time posting here. I have a field named Profile Last
Updated which is a date, MMDDYYY. I want to automatically add three months to
that date to come up with a Profile Check Date. Any ideas on how to do this?

Thanks

 

[Guest]

Create a query based on the table, add another field to it using the DateAdd
function to add three month to the Date field

Profile_Check_Date: DateAdd("m",3,[Profile Last Updated])

Or in SQL
Select DateAdd("m",3,[Profile Last Updated]) As Profile_Check_Date From
TableName