Date Difference

[d44]

I am looking to use the date difference function(or similar) to calculate an employee's retiral date by using their Date of Birth and by using the age when they would retire. i.e. 65.

Thanks

 

[dgillz]

You need the dateadd() function to do this.

Dateadd("y",65,{DateOfBirth}) will give you when they turn 65.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com