- Data Integration
- All Products
The LEAD function will access rows based on the offset argument and ignore the frame.
Groups the rows according to customer code so that calculations are based on individual customers.
Arranges the data chronologically by ascending start date.
LEAD ( StartDate, 1, '01-Jan-2100' )
ADD_TO_DATE ( LEAD ( StartDate, 1, '01-Jan-2100' ), 'DD', -1, )
Updated March 06, 2023