I need to add 1 year to a date in crystal reports

rorybrady
rorybrady used Ask the Experts™
on
Hello I have a crystal report that pulls the replacement date for our computers. I need to be able to add 1 year to this date.

i.e. vwreports.prjectedReplacementDate + 1

Does anyone know how to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try this

DateAdd('yyyy',1,{vwreports.prjectedReplacementDate})

You were adding 1 day.

mlmcc

Author

Commented:
Perfect! Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial