locked
Date difference problem in crystal report formula :( RRS feed

  • Question

  • User1000038322 posted

    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....

    Wednesday, November 30, 2011 1:26 AM

All replies

  • User-2001765250 posted

    Refer the following link 

    http://www.youtube.com/watch?v=zLvModCDx9A

    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.

    Wednesday, November 30, 2011 4:12 AM