Alanj Posted April 12, 2011 Share Posted April 12, 2011 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 Link to comment Share on other sites More sharing options...
comment Posted April 12, 2011 Share Posted April 12, 2011 it has decided to drop a year. For example...? Link to comment Share on other sites More sharing options...
Alanj Posted April 12, 2011 Author Share Posted April 12, 2011 For example...? Two actual examples, 5 Jun 2009 to today = 0.9yrs 20 Jul 2007 to today = 2.8 yrs Link to comment Share on other sites More sharing options...
comment Posted April 12, 2011 Share Posted April 12, 2011 Are both calculation fields unstored? Link to comment Share on other sites More sharing options...
Alanj Posted April 12, 2011 Author Share Posted April 12, 2011 One of them wasn't, and it has now fixed the problem..... I am really grateful for your prompt assistance Best regds Alan Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4763 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now