Dates and ages.... I really need help

[Mabou]

Hi all,

I have seen similar questions posted here but they always include a calculation in relation to the CURRENT date... this question is a bit different....

Task: I am calculating property tax schedule AGES for all of my video equipment.

Problem: I need to calculate the age in years (1,2,3,4 etc) from two dates (Purchase date and Assessment date). I will be manually updating the assessment date each year as I recalculate the property tax.

IF the purchase date is AFTER the assessment date, I need a "0" in the age field.

IF the purchase date is BEFORE the assessment date but in the same year, I need to age field to show a "1"

Then, of course, if the equipment is older, I need to have the proper age inserted into the Age field.

I have no doubt that some of you will shake your head at how easy this is.....

But thank you for your help.

Matt

[Lee Smith]

Take a look at this file "Software Management Starter Solution"

http://collection.filemaker.com/collection/search_results.jsp

HTH

Lee

[Mabou]

Lee,

yikes... after spending quite a bit of time looking through the solutions provided, I did not see anything that sparked an idea of how to resolve my DB issues.

Thanks anyway Lee.

[Lee Smith]

The link provided takes you to a list of files. "Software Management Starter Solution" is the fourth one from the bottom. The pictures show a depreaction schedule. Isn't that what you wanted?

Lee

[-Queue-]

How about

Case(

DatePurchase > DateAssessment; 0;

Year(DatePurchase) = Year(DateAssessment); 1;

Year(DateAssessment) - Year(DatePurchase) - (DateAssessment < Date( Month(DatePurchase); Day(DatePurchase); Year(DateAssessment) ))

)

?