Find Anniversary Date

[trinity_53]

Hi, I would like to be able to work out an anniversary date based on a client's registration date. so far I can do it by using DateAdd but only get either one year forward or if using a - then one year back. What I really need it to do is let me know when their anniversary is due from now. Hope someone can help. Thank you

[zusulik]

Hi trinity,

You could first find the anniversary date (using DateAdd as you mentioned above) and then use DateDiff to find the date difference between anniversary and now.

The syntax for DateDiff is as follows:

DateDiff (intervalType, startDateTime, endDateTime), where interval type can be days, weeks, months, etc.

For more info see Crystal Help.

Good luck.