How to count the number of years between two dates

ma ouml

Hi friends,

I will rest my question because I did not turn the good answer

I want to calculate the number of years between start date and end date in crystal report

I have tested many functions in crystal report like this one DateDiff ("yyyy", {decompte.Date_demarrage}, {decompte.Date_fin}): in case the number of years = 1 it shows me 1.00

In case of the number of years <1 it shows me for example 260

I do not want it like that I want when the number of years == 1 shows me 1

When the number is less than 1 it shows me 1 and so on

I will be very happy if I find someone who can help me

And thanks in advance friends

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikandan Murugesan9y ago
Accepted answer
The following contains the code that used for calculate the no.of.years,days,months between the given two dates : http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14260
Rajkiran Swain9y ago
Example :

numbervar a := (LeavingDate-HiringDate);
numbervar b := a mod 365;
numbervar c := b mod 30;

ToText(Truncate(a/365),0) +" yr(s) "+ ToText(Truncate(b/30),0) +" mth(s) "+ ToText(c,0) +" day(s)";