It's certainly possible - but you need to clarify the rounding rule. Months come in varying lengths, and you need to decide when exactly does a "complete month" elapse. For example, starting at Jan 31, when does one complete one month?
That is a good point about the rounding that I didn't actually think about.
Can a filemaker calculation take the average of 365 / 12 = 30.4?
Or is it clever enough to make the calculation to include how many days there are in each month?
i.e January 31
I have seen a calculation in a template that comes with filemaker that determines the quarter of the year it falls in based on the month on the drop down calenders. This calculation formula includes all 12 months followed by a 1,2,3,4 based on the quarter. Is this formula something that can be used as a basis for what I am trying to do?
Thanks for the help.
I believe Filemaker can do any date calculation you can think of (at least I haven't come up against one that couldn't be done yet). The problem here is not "how", but "what".
If you can define the rules in a way that would enable a person to get the corect result using paper and pencil (or perhaps a calendar and fingers in this case), it can be done in Filemaker.
As an example, this calculates the difference in months, ignoring the day of month =
12 * ( Year ( EndDate ) - Year ( StartDate ) ) + Month ( EndDate ) - Month ( StartDate )
Works like a treat. Exactly what I was after.
You are a superstar