Last post Nov 30, 2011 04:12 AM by Sagar Kamate
Nov 30, 2011 01:26 AM|amin.net.net|LINK
I want to get the total service years,months and days with current datte in crystal report.
say Joining date: 15/04/1995
so the difference with current date (30/11/2011) is: 16 Years 7 Months 15 Days
How can I do this in Crystal report by using Crystal report formula
I know this type of formula, DateDiff ("yyyy",Current_Date,Join_Date) or
DateDiff ("m",Current_Date,Join_Date) or DateDiff ("d",Current_Date,Join_Date) but these are not working for this situation.
please help me....
Nov 30, 2011 04:12 AM|Sagar Kamate|LINK
Refer the following link
I think you have to create the formula for that. and just calculete the Date month and Year and concantenate them in which format you want.
The link contain the video lessions for crystal reports formula fields.