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%)