months elapsed between two dates

[keelbolt]

I have a column of different dates. Each date is the date on a record of when a subscription to a magazine lapsed.

I have a global column showing today's date.

I need a formula that will tell me the number of months that have elapsed between the two dates.

I am working in Filemaker Pro 5

Can anyone help?

[comment]

Try:

12 * Year ( gToday ) + Month ( gToday ) - 12 * Year ( StartDate ) - Month ( StartDate ) - ( gToday < Date ( Month ( gToday ), Day ( StartDate ) , Year ( gToday ) ) ) 

BTW, you don't need the global field for this - you can use Status(CurrentDate) directly (just make sure the calculation is unstored).

[LaRetta]

I have a column of different dates. Each date is the date on a record of when a subscription to a magazine lapsed.

These date fields (holding the lapsed subscription date) should really be records in a related table. It will be much easier to work with because the same calculation provided by Comment can then work for ALL the fields instead of requiring a separate calculation for each date field.

And if the subscriptions are records, you can easily track, count, and report on the information. :wink2: