Notre Dame de l'Assomption Arichat, Nova Scotia
Baptisms - 1839 through 1911
Some Characteristics of The Arichat Baptisms Data Base
The dates used in the Baptism and Birth date fields are treated as pure "character strings" and not as "numbers". The format for these dates are YYYY-MM-YY - where YYYY is the four character year numeral, MM is the two character month numeral (e.g. July is "07"), and DD is the two character day numeral. For example, 9 Jul 1891 is written as 1891-07-09. Note that lead zeroes, if appropriate, must be included in the month and day.
In these dates, if any of the Year, Month, or Day is not known then all zeros are substituted. Thus, an unknown month and day in the year 1891 would be written as 1891-00-00.
Be aware that, because the dates are character strings, all comparisons in any date criteria that you submit will be made from the left. Thus, the criteria " > 1891" is all that is needed to select all dates that are greater than 1891-00-00.
In general, spaces within surnames have been omitted, even when the name could be divided into two parts with each part capitalized - as in "LaBlanc". The internal capitalization of such names is less consistent throughout the file. Where this might effect the desired result, it would be advisable either 1) to include both forms of the name, joined by an OR; or 2) use the UPPER modifier.