| Function | Short Description |
|---|---|
| AgeAt | Returns an Individual's age at the time of a given event. Used in the query Age At Marriage. |
| CalcDate | Calculates a date from a given date and a given number of years, months and or days (which can have negative values). |
| Date | See Type-Specifier functions. |
| DateAt | This function is typically used as a parameter to another function. It allows you to pass a date to a
function, specifying either a year, a year and month, or a year, month and day.
See also Today |
| DateIf | Takes a boolean expression (True or False) and 2 dates. If the boolean expression evaluates as True, the first date is returned; otherwise the second date is returned. |
| Day | Returns the day part of a given date (e.g. for 22nd May, 1982 it would return 22). See also Month and Year. |
| DayNumber | If you started counting days on January 1st AD 1 (counting that day as day 1), this function will return the day number for any given date. For example, the day number for 1st January, 2008, is 733,044. |
| DayOfWeek | Returns the day of the week ("Sunday", "Monday", etc) for any given date. |
| EstimatedAgeAt | Uses available information to estimate a person’s age at a given date. |
| EstimatedBirthDate | Uses available information to estimate a person’s date of birth. |
| EstimatedDeathDate | Uses available information to estimate a person’s date of death. |
| GetDataWarning | Gives a warning of any known possible problem with a given data item. Can be used with any data item, but in fact currently only warns of possible problems with dates. |
| LifeDates | Returns birth and death dates in a convenient format. If birth and/or death dates are not available, it will return baptism, christening and/or burial dates instead, if these are known. This function is used in many text schemes, in reports and in the Age At Death query. |
| LifeDates2 | This function behaves exactly like LifeDates, except that it will return a hyphen for individuals who have none of the relevant dates. This is convenient if you want to display a person who has no dates like this: "John Smith ( - )". |
| Month | Returns the month part of a given date as a number between 1 and 12 (e.g. for 22nd May, 1982 it would return 5). See also Day and Year. |
| NullDate | Returns True if a given date is Null. |
| Timespan | Calculates the number of years, months or days between any two dates. |
| Today | This function is typically used as a parameter to another function. It allows you to pass today’s
date to a function.
See also DateAt. |
| Year | Returns the year part of a given date (e.g. for 22nd May, 1982 it would return 1982). See also Month and Year. |