Returns the earliest or the most recent date in an array.
Syntax:
a #EFFDATE b
where:
a = blank, 0, 1 or 2.
b = an effected dated array or a start & stop array.
When a is: The operator returns the: 0 or blank most recent effective date or the most recent start date 1 earliest effective date or the earliest start date 2 operator returns the most recent stop date 3 earliest stop date
Example 1:
0 #EFFDATE Pay - returns the most recent start date, with a value, of the start & stop dated array PAY.
Example 2:
3 #EFFDATE Hours - returns the earliest stop date, with a value, of the start & stop dated array Hours.
Example 3:
1 #EFFDATE Status – returns the earliest effective date of the effective dated array Status.
