Date formula needed

[debizabor]

I need a formula to have an anniversay date returned basing it on a [date hired] field. Can you help me?

 

[humbleprogrammer]

You can use the DateAdd function.

= DateAdd("d", 30, [date hired]) would add 30 days to the hired date.

Hope this helps.

 

[debizabor]

Thanks for the help! How would I return a date for the present year? i.e. Someone was hired on 01/15/1998. i need the anniversary to return as 01/15/2003 for this year, and 01/15/2003 for next year and so on.

 

[humbleprogrammer]

Try something like this:

= Format([date hired],"mm/dd&quot & "/" & Format(Date(),"yyyy&quot

 

[03SCBeast]

humble...I've been trying for about two days without success to use a Datepart function to extract the month and date of an effective year and calculate an anniversary date based on the current year if the effective date has been more than 365 days. You inadvertantly answered my question with your response and this code works well. Here's my expression:

Anniversary_Date: IIf(DateDiff("d",Date(),[Effective_Date])<-365,Format([Effective_Date],"mm/dd") & "/" & Format(Date(),"yyyy"),[Effective_Date])

Hopefully this may inadvertantly help someone else who might be trying to accoplish the same feat.