Note: The Rootsweb Mailing Lists will be shut down on April 6, 2023. (More info)
RootsWeb.com Mailing Lists
Total: 4/4
    1. Re: [RMagic] Like a list of "years married"
    2. Tom Holden via
    3. However, for a person with multiple marriages, I don't think RootsMagic reports are smart enough to output the corresponding divorce or death dates on the same line as the marriage date for a given couple. It may output them in the order the facts were entered and thus mix up on the same line facts from two couples. I suspect the only way to do this reliably is an export to some software that does give that report or to develop a custom SQLite query of the RootsMagic database. Tom > On Feb 14, 2015, at 7:19 PM, Sue Maxwell via <[email protected]> wrote: > > There is a marriage report but it does not do any calculation of married time. You can use the calculator to subtract dates but only for one person at a time. > > I can't even think of a possible custom report that would give you what you want. > > You could create a custom report containing marriage dates and divorce dates (and/or death dates). Then export the data to Excel and do the calculation there. > > Sue > > >> On Feb 14, 2015, at 4:22 PM, Michael Fike via <[email protected]> wrote: >> >> I tried searching the archives so as not to duplicate this question ... but I did not find it. >> I'm new to RM and I would like to create a report showing how long a couple was married. >> Nothing fancy. Once someone puts me down the right path I should be able to go from there. >> Thanks for the assistance. >> mike >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

    02/14/2015 03:31:43
    1. Re: [RMagic] Like a list of "years married"
    2. Sue Maxwell via
    3. You are right on Tom. It's not a great idea, but at least a possibility. In RM there is no built in way to calculate the combination of dates to relationships. Knowing you, you probably could do it with SQLite. ???? Sue > On Feb 14, 2015, at 8:31 PM, Tom Holden <[email protected]> wrote: > > However, for a person with multiple marriages, I don't think RootsMagic reports are smart enough to output the corresponding divorce or death dates on the same line as the marriage date for a given couple. It may output them in the order the facts were entered and thus mix up on the same line facts from two couples. > > I suspect the only way to do this reliably is an export to some software that does give that report or to develop a custom SQLite query of the RootsMagic database. > > Tom > >> On Feb 14, 2015, at 7:19 PM, Sue Maxwell via <[email protected]> wrote: >> >> There is a marriage report but it does not do any calculation of married time. You can use the calculator to subtract dates but only for one person at a time. >> >> I can't even think of a possible custom report that would give you what you want. >> >> You could create a custom report containing marriage dates and divorce dates (and/or death dates). Then export the data to Excel and do the calculation there. >> >> Sue >> >> >>> On Feb 14, 2015, at 4:22 PM, Michael Fike via <[email protected]> wrote: >>> >>> I tried searching the archives so as not to duplicate this question ... but I did not find it. >>> I'm new to RM and I would like to create a report showing how long a couple was married. >>> Nothing fancy. Once someone puts me down the right path I should be able to go from there. >>> Thanks for the assistance. >>> mike >>> >>> >>> =================================== >>> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >>> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >>> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message >> >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

    02/14/2015 02:44:56
    1. Re: [RMagic] Like a list of "years married"
    2. Tom Holden via
    3. Okayyy, I did something with SQLite. I think it works except for outliers such as a couple in the distant past who are surely deceased for whom there is no event to terminate the marriage and probably not for a couple who married, divorced and remarried. In both cases, it will give results but maybe not realistic. Also, it just calculate the length of marriage in years from the years of the events, not down to months and days. Interested? I won't get to posting it for a while. Tom On Sat, Feb 14, 2015 at 11:44 PM, Sue Maxwell <[email protected]> wrote: > You are right on Tom. It's not a great idea, but at least a possibility. > In RM there is no built in way to calculate the combination of dates to > relationships. Knowing you, you probably could do it with SQLite. ???? > > Sue > > > > > On Feb 14, 2015, at 8:31 PM, Tom Holden <[email protected]> wrote: > > > > However, for a person with multiple marriages, I don't think RootsMagic > reports are smart enough to output the corresponding divorce or death dates > on the same line as the marriage date for a given couple. It may output > them in the order the facts were entered and thus mix up on the same line > facts from two couples. > > > > I suspect the only way to do this reliably is an export to some software > that does give that report or to develop a custom SQLite query of the > RootsMagic database. > > > > Tom > > > >> On Feb 14, 2015, at 7:19 PM, Sue Maxwell via < > [email protected]> wrote: > >> > >> There is a marriage report but it does not do any calculation of > married time. You can use the calculator to subtract dates but only for one > person at a time. > >> > >> I can't even think of a possible custom report that would give you what > you want. > >> > >> You could create a custom report containing marriage dates and divorce > dates (and/or death dates). Then export the data to Excel and do the > calculation there. > >> > >> Sue > >> > >> > >>> On Feb 14, 2015, at 4:22 PM, Michael Fike via < > [email protected]> wrote: > >>> > >>> I tried searching the archives so as not to duplicate this question > ... but I did not find it. > >>> I'm new to RM and I would like to create a report showing how long a > couple was married. > >>> Nothing fancy. Once someone puts me down the right path I should be > able to go from there. > >>> Thanks for the assistance. > >>> mike > >>> > >>> > >>> =================================== > >>> RM list Archives: > http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > >>> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > >>> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > http://blog.rootsmagic.com/ > >>> > >>> > >>> ------------------------------- > >>> To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message > >> > >> > >> > >> =================================== > >> RM list Archives: > http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > http://blog.rootsmagic.com/ > >> > >> > >> ------------------------------- > >> To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message >

    02/15/2015 10:37:49
    1. Re: [RMagic] Like a list of "years married"
    2. Jon Czarowitz via
    3. With all of the above in mind, Using the Marriage Status at death of a spouse would terminate the marriage so RM could calculate a length of marriage. The Spouse death is not shown on the partner's facts otherwise. This means doing it as a routine as you go. Jon *** On Sun, Feb 15, 2015 at 4:37 PM, Tom Holden via < [email protected]> wrote: > Okayyy, I did something with SQLite. I think it works except for outliers > such as a couple in the distant past who are surely deceased for whom there > is no event to terminate the marriage and probably not for a couple who > married, divorced and remarried. In both cases, it will give results but > maybe not realistic. Also, it just calculate the length of marriage in > years from the years of the events, not down to months and days. > Interested? I won't get to posting it for a while. > > Tom > > On Sat, Feb 14, 2015 at 11:44 PM, Sue Maxwell <[email protected]> > wrote: > > > You are right on Tom. It's not a great idea, but at least a possibility. > > In RM there is no built in way to calculate the combination of dates to > > relationships. Knowing you, you probably could do it with SQLite. ???? > > > > Sue > > > > > > > > > On Feb 14, 2015, at 8:31 PM, Tom Holden <[email protected]> wrote: > > > > > > However, for a person with multiple marriages, I don't think RootsMagic > > reports are smart enough to output the corresponding divorce or death > dates > > on the same line as the marriage date for a given couple. It may output > > them in the order the facts were entered and thus mix up on the same line > > facts from two couples. > > > > > > I suspect the only way to do this reliably is an export to some > software > > that does give that report or to develop a custom SQLite query of the > > RootsMagic database. > > > > > > Tom > > > > > >> On Feb 14, 2015, at 7:19 PM, Sue Maxwell via < > > [email protected]> wrote: > > >> > > >> There is a marriage report but it does not do any calculation of > > married time. You can use the calculator to subtract dates but only for > one > > person at a time. > > >> > > >> I can't even think of a possible custom report that would give you > what > > you want. > > >> > > >> You could create a custom report containing marriage dates and divorce > > dates (and/or death dates). Then export the data to Excel and do the > > calculation there. > > >> > > >> Sue > > >> > > >> > > >>> On Feb 14, 2015, at 4:22 PM, Michael Fike via < > > [email protected]> wrote: > > >>> > > >>> I tried searching the archives so as not to duplicate this question > > ... but I did not find it. > > >>> I'm new to RM and I would like to create a report showing how long a > > couple was married. > > >>> Nothing fancy. Once someone puts me down the right path I should be > > able to go from there. > > >>> Thanks for the assistance. > > >>> mike > > >>> > > >>> > > >>> =================================== > > >>> RM list Archives: > > http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > > >>> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > > >>> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > > http://blog.rootsmagic.com/ > > >>> > > >>> > > >>> ------------------------------- > > >>> To unsubscribe from the list, please send an email to > > [email protected] with the word 'unsubscribe' > without > > the quotes in the subject and the body of the message > > >> > > >> > > >> > > >> =================================== > > >> RM list Archives: > > http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > > >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > > >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > > http://blog.rootsmagic.com/ > > >> > > >> > > >> ------------------------------- > > >> To unsubscribe from the list, please send an email to > > [email protected] with the word 'unsubscribe' > without > > the quotes in the subject and the body of the message > > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message -- -- *Jon P Czarowitz*, NHC, GF, GGF, IGC Hempel Genealogist since 1986 Retired International Genealogist for http://www.clancunninghamintl.org RootsMagic 7 http://www.rootsmagic.com CUNNINGHAMS TOGETHER - CUNNINGHAMS WORLDWIDE!

    02/16/2015 05:38:52