Subtract dates, and seeing the result in years (ie yy.yy

[CEG]

I have to provide a report showing length of service of employees over the last two years.

I have used the following:

if{EMP_RECORD.E_DATE_LEFT}<DateValue (1967,12,31)
then datediff
(&quot;y&quot;,CurrentDate,{EMP_RECORD.E_DATE_JOINED})
else
{EMP_RECORD.E_DATE_LEFT}-{EMP_RECORD.E_DATE_JOINED}

This works but shows the result in number format.

ie (To-day 30/07/2002)-(Startdate 25/03/1996) = 2318.

How can I get it to display in yy.yy format The above should read 6.06 years.

Appreciate some advice on this.

 

[IanWaterman]

Can't you just divide the result by 365 .

For your example that yields 6.35 which looks about right as the difference is 6 yrs, 4 months and 5 days. Can't see how you arrive at 6.06.

Ian

 

[dgillz]

Charge your else statement to:

Datediff(&quot;y&quot;,EMP_RECORD.E_DATE_LEFT},EMP_RECORD.E_DATE_JOINED}) Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[dgillz]

Charge your else statement to:

Datediff(&quot;y&quot;,{EMP_RECORD.E_DATE_LEFT},EMP_RECORD.E_DATE_JOINED}) Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[CEG]

Many thanks.

Why I could not see it is a mystery.

Thanking you once again.

 

[Naith]

Or DateDiff(&quot;yyyy&quot;,{},{})