The following expression is the simplest way to turn a start/stop array into an effective date array. Once you get the start and stop dates and the values, you can do almost anything to them before you use #ARRAY to create the final effective date array.

B_DT:= #START Salary & ; start dates
E_DT:= #STOP  Salary & ; stop dates
V:=    #VALUE Salary & ; values (i.e., the reported salaries)

12 #ARRAY(B_DT,V) ; create an effective date array: (effective date,values)

​

Other possible expressions to create the array from the temporary variables are:

12 #ARRAY(E_DT,V)

12 #ARRAY(B_DT,B_DT) ; May be useful to isolate start event dates

12 #ARRAY(B_DT,E_DT)

12 #ARRAY(E_DT,E_DT) ; May be useful to isolate stop event dates