Date Calculation

[Alanj]

I have an application where I calculate the difference between 2 dates using the calculations:-

Today = Get ( CurrentDate )

Round ((Today - Date_Joined)/365 ; 1 )

and the resulting figure is 1 year out, ie it will tell me 2 years instead of 3

I know that this worked initially but for some reason that I cannot fathom out it has decided to drop a year.

I would be very grateful if some kind person can shed some light on this as I have checked date formats and everything and drawn a blank

Many thanks in anticipation

Alan

[comment]

it has decided to drop a year.

For example...?

[Alanj]

For example...?

Two actual examples,

5 Jun 2009 to today = 0.9yrs

20 Jul 2007 to today = 2.8 yrs

[comment]

Are both calculation fields unstored?

[Alanj]

One of them wasn't, and it has now fixed the problem.....

I am really grateful for your prompt assistance

Best regds

Alan