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.
