Syntax

%EffDtCheck(recordname [correlation_id1], correlation_id2, as_of_date)

The %EffDtCheck construct expands into an effective date subquery suitable for a Where clause.

recordname: Specify the record name to use as the record in the effective-date checking. This can be bind variable, a record object, or a record name in the form recname.
correlation_id1: (Optional) Specify the letter used inside the effective-dating subselect. If this parameter isn’t specified, recordname is used.
correlation_id2: Specify the letter already assigned to the main record in the From clause of the SQL statement.
as_of_date: Specify the date to use in the effective date. This can be a bind variable, a variable, or a hard-coded date. The value for as_of_date is automatically wrapped in%DateIn unless as_of_date is already wrapped in %DateIn or refers to other database columns.