I am very new to Filemaker. I am trying to use Filemaker instead of Excel for a few projects and I am having a hard time getting some of the calculations worked out.

I am trying to get Filemaker to calculate the age of an item using the current date and a field called "manufacturedate". I got it to display a result in whole years (for example 2.0 years) but I need it to break it down into partial years (for example 2.6 years)

I am sure this is easy, but I have tried a bunch of combinations of code and tried using formulas from some of the sample files with no luck.

Try something like:

Round ( ( Get (CurrentDate) - ManufactureDate ) / 365.2425 ; 1 )

This topic comes up from time to time. I just did a search for [color:red]+Years +Month +Days, and pulled up all kinds of hits. Note the Pluses [color:red]+, they are important to narrowing your search criteria down,

Start with this one Link and pay attention to any posts by comment.

Try something like:

Round ( ( Get (CurrentDate) - ManufactureDate ) / 365.2425 ; 1 )

Awesome! Worked like a charm. Thanks!