Report: Marriages This Month
Description: Their anniversary is this month. [NOTE: Marriage Dates containing Abt., Bef., Bet., or Aft. may not have occurred this month.]
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,sex,if(sex='M',families1.marrdate,families2.marrdate),if(sex='M',families1.marrplace,families2.marrplace), tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE ((( if(sex='M',families1.marrdate,families2.marrdate) LIKE "%AUG%" )) AND ((tng_people.living !=1 && tng_people.private != 1))) AND tng_people.gedcom = "OurFamilyTree" ORDER BY lastname,firstname,if(sex='M',families1.marrdatetr,families2.marrdatetr)
Matches 1 to 50 of 223 » Comma-delimited CSV file
| # | Last Name, Given Name(s) | Marriage Date | Marriage Place | |
| 1 | +, Constance, Queen consort of France | F | 25 Aug 1003 | |
| 2 | +, Isabelle, Queen consort of England | F | 24 Aug 1200 | Bordeaux, Gironde, Aquitaine, France  |
| 3 | +, King John of England | M | 24 Aug 1200 | Bordeaux, Gironde, Aquitaine, France |
| 4 | +, King Robert II de France | M | 25 Aug 1003 | |
| 5 | Adams, George Washington | M | 23 Aug 1852 | Peel, Wellington, Ontario, Canada |
| 6 | Adams, John Quincy | M | 3 Aug 1892 | |
| 7 | Adams, Robert | M | Aug 1695 | |
| 8 | Adams, Roger William | M | 19 Aug 1934 | |
| 9 | Adams +, Reverend Ezra | M | 8 Aug 1833 | Grimsby, Niagara, Ontario, Canada |
| 10 | Armstrong, Roy Hudson | M | 9 Aug 1947 | Saskatoon, Saskatchewan, Canada |
| 11 | Atkinson +, Thomas | M | 5 Aug 1719 | |
| 12 | Balcom +, Henry | M | 12 Aug 1666 | Charlestown, Suffolk, Massachusetts, USA |
| 13 | Ball, Henry Durrell | M | 31 Aug 1910 | Chautauqua, New York, USA |
| 14 | Benjamin, Hartwell | M | 24 Aug 1910 | Muskegon, Muskegon, Michigan, USA |
| 15 | Bevys +, Alice | F | 30 Aug 1595 | Exeter, Devon, England |
| 16 | Bird, Homer Bartow | M | 6 Aug 1911 | Camak, Warren, Georgia, USA |
| 17 | Boots, Anna Elda | F | 13 Aug 1846 | Montgomery, Indiana, USA |
| 18 | Box, Lenzena | F | 24 Aug 1893 | Petoskey, Emmet, Michigan, USA |
| 19 | Boyum, Hazel Alvera | F | 21 Aug 1931 | Ottertail, Otter Tail, Minnesota, USA |
| 20 | Boyum, Hazel Alvera | F | 1 Aug 1982 | Charlotte, Florida, USA |
| 21 | Brandon, Emily Elizabeth | F | 10 Aug 1862 | Berrien, Georgia, USA |
| 22 | Bray, Benjamin Asbury | M | 10 Aug 1879 | Clarke, Georgia, USA |
| 23 | Bray +, ^ Private Benjamin | M | 27 Aug 1840 | Madison, Georgia, USA |
| 24 | Brent, William | M | 9 Aug 1734 | |
| 25 | Brewer +, Catherine | F | 4 Aug 1812 | Oglethorpe, Georgia, USA |
| 26 | Bridges, Nathaniel C. | M | 6 Aug 1850 | Oglethorpe, Georgia, USA |
| 27 | Brooks, Frank D. | M | 20 Aug 1923 | Washington, Wilkes, Georgia, USA |
| 28 | Brown, Timothy | M | 30 Aug 1750 | Stow, Middlesex, Massachusetts, USA |
| 29 | Browning, Sarah | F | 22 Aug 1837 | Clarke, Georgia, USA |
| 30 | Burt, Salley | F | Bef. Aug 1788 | |
| 31 | Burton +, Judith | F | "He married Judith Burton, daughter of Robert and | |
| 32 | Bush, Senator Preston Sheldon | M | 6 Aug 1921 | Kennebunkport, York, Maine, USA |
| 33 | Carter, Charles T. | M | 19 Aug 1782 | Granville, North Carolina, USA |
| 34 | Catherwood, Beatrice | F | 11 Aug 1923 | Tramping Lake, Saskatchewan, Canada |
| 35 | Chapman, Amazon Elizabeth | F | 20 Aug 1923 | Washington, Wilkes, Georgia, USA |
| 36 | Chapman, Luna C. | F | 6 Aug 1911 | Camak, Warren, Georgia, USA |
| 37 | Chapman, Robert Augustus I | M | 24 Aug 1893 | Sparta, Hancock, Georgia, USA |
| 38 | Chapman + ??, William Gulielmus | M | 17 Aug 1584 | Frome, Somerset, England |
| 39 | Clement +, Elizabeth | F | 1 Aug 1734 | |
| 40 | Cluet + ??, William | M | 31 Aug 1658 | Milton Abbas, Dorset, England |
| 41 | Colbert, Martha W. | F | Aft. 26 Aug 1828 | |
| 42 | Coolidge, Elizabeth | F | 21 Aug 1740 | Watertown, Middlesex, Massachusetts, USA |
| 43 | Corneliusdatter Vatne, Karen | F | 5 Aug 1854 | Stavanger, Rogaland, Norway |
| 44 | Crow, Martin Towne II | M | 22 Aug 1837 | Clarke, Georgia, USA |
| 45 | Davidson, Agnes | F | 19 Aug 1793 | Acton, Middlesex, Massachusetts, USA |
| 46 | Davis, Mabel Irene | F | 13 Aug 1932 | |
| 47 | de Burghersh +, Dame Elizabeth | F | Bef. 2 Aug 1354 | |
| 48 | Drake, Herbert Marcus | M | 22 Aug 1925 | Lakota, Nelson, North Dakota, USA |
| 49 | Dudley + |, William | M | 24 Aug 1636 | Ockley, Surrey, England |
| 50 | Duncan, Mary | F | 17 Aug 1757 | Petersham, Worcester, Massachusetts, USA |
1 2 3 4 5 Next»