Family Historian User Group

Someone has asked me if their parents' 70th wedding anniversary represents a record anniversary within our family.

Is there a query available to show the length of a marriage (i.e. from marriage date to divorce or death of one partner)?

ID:6694

I could not think of a quick way in a query, but I have done a quick plugin.

You'll need to 'sanity' check results where there the life dates are not complete for the partners.

https://www.dropbox.com/s/r7u0id5o8saaz ... ort.fh_lua

Many thanks. Much appreciated.

It almost works except for when there is a death date for the wife but no death date for the husband, when it then seems to use today's date to calculate the marriage length.

I'll see if I can fix it, might be a day or so as I am a bit busy with other things at the moment.

I didn't get any like that, but those without dates had an lifespan of about 90 assumed.
I also had a few negative results, but a bit of extra research sorted them out.

There are actually two problems with this plugin, one is easy to fix the other needs a bit more thinking about.

The problem as reported by forpm is down to if Husband Estimated Death Date is a future date then a Null is returned which throws the calculations out. Can prove this by just checking option to estimate future death dates.

See example



Wrong Marriage Length


Correct Marriage Length


The other fix is slightly easier and justs needs variable in EstimatedDeathDate changed from MID to LATEST. See example



Wrong Marriage Length


Correct Marriage Length

I have fixed the Null problem on the Estimated dates, and changed it over to LATEST, the same link should work.

I wondered about skipping people with missing dates, but could not decide where to draw the line as for example my own marriage has both partners living so would be skipped from the report if I omit records where both have no death dates.

Thanks for all this and to Jane for writing the plugin.

I think there is still a problem, now in reverse to the one I posted earlier.

If there is a death date for the husband, but not for the wife, then the marriage length is calculated using today's year.

I have given it another go any better?

Seems to be fine now for me.

I got no change in results between 0.2 & 0.3 , but I was happy anyway.
0.3 now correctly shows that it is running in the plugin window, 0.1 & 0.2 did not.
An excellent tool for highlighting incomplete data. I will be using it daily (ish)

Jane - that is perfect now. Thanks so much for your help.

This has now been added to the plugin store, it has a couple of extra columns and allows the selection of all or selected records.