Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am generating dates from start date to end date, but end date is max date of (original_PPAP, new_PPAP) max one will consider as end date.
start_date | original_PPAP | new_PPAP |
2021-08-03 | 10/14/2022 | 6/26/2023 |
2021-08-03 | 7/23/2022 | 5/31/2022 |
2021-08-03 | 4/9/2022 | 4/9/2022 |
LOAD [Study #],
Date(start_date + IterNo() - 1) as Date_Range
RESIDENT Input_Data
While Date(start_date + IterNo() - 1) <= Original_PPAP
;
for one field the dates are generating,
please help me for generating dates for end date max one.
RangeMax(original_PPAP, new_PPAP)
-Rob