- Create PolicyDetails file with multiple records having data as (PolicyNo, PolicyHolderName,
PolicyDate,PolicyAmount ). Sample data is provided. Add 5 more records in these data.
- Calculate 3 installment dates from PolicyDate using Modified Java script step
First installment date should be within 3 days of PolicyDate.
Second installment date should be after 3 months of PolicyDate.
Third installment date should be after 6 months of PolicyDate.
- Store all details along with installment dates in excel output file.