hartmut77 Posted March 26, 2005 Posted March 26, 2005 Hello I have three fields "pipeage" which is a date field "today "which is a date field and "yearsold" which is a calculation field I am trying to calculate the number of years the pipe has been there. So I am trying to get today field to display the year 2005 which I can't get it to do and then subtract for example 1950 from 2005 as 1950 would be in the "pipeage" field. and the answer would be 55 years. But I just can't get it to work. Could someone please guide me here Thanks Dave
MoonShadow Posted March 26, 2005 Posted March 26, 2005 Year(Get(CurrentDate)) - Year(Pipeage) You don't need that today field, only one unstored YearsOld calculation.
Recommended Posts
This topic is 7276 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