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

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

--
\\// Live Long and Prosper \\//
BS"D


"Maddini" wrote:

> 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