Functions (all)

DateAt

Function Name:

DateAt

Description:

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.

Minimum FH Version:

3.1

No. of Parameters:

3

Return Type:

Date

Parameter 1:

A number. The year (A.D. only).

Parameter 2:

A number. The month. This value is optional. If not supplied, the month value will be 0. 0 is a special value, meaning that the month is not know. Otherwise, the value must be in the range 1-12.

Parameter 3:

A number. The day. This value is optional. If not supplied, the day value will be 0. 0 is a special value, meaning that the day is not know. Otherwise, the value must be in the range 1-31. You must not supply a non-zero day if you have not supplied a non-zero month.

Examples:

=DateAt(1901)

or

=DateAt(["Year"])

or

DateAt(1939,9,3)

The first example gives the year 1901. The second will result in a prompt being put up for the year. The 3rd returns the date, 3rd September, 1939. This function can be useful as a parameter to other functions. For example:

=EstimatedAgeAt(%INDI%,DateAt(1901), MIN)

will return a person’s minimum possible estimated age, in 1901.