Functions (all)

DateIf

Function Name:

DateIf

Description:

Returns the parameter 2 date if the boolean expression in parameter 1 is True. If the boolean expression is not True, it returns the parameter 3 date.

See Conditional Expressions.

Minimum FH Version:

4.0

No. of Parameters:

3

Return Type:

Date.

Parameter 1:

A boolean expression (True or False)

Parameter 2:

A date. The date to return if parameter 1 is True.

Parameter 3:

A date. The date to return if parameter 1 is False.

Examples:

=DateIf(%INDI.SEX% = "Male",%FAM.WIFE>BIRT.DATE%,%FAM.HUSB>BIRT.DATE%)