Check the date is within the range

Help Activities
, ,
1

APP1.xlsx (9.6 KB)
test1.xlsx (9.2 KB)

I attached two input excel file “test” and “app”

First, I take the date from the column “TXNDATE” in Test excel file and check the
date is within the start date and end date in App excel file.
If its inbetween the start and end date, then move to next step
If No, Change the start date to the “1st of the month in which the transaction date" is mentioned

Check the End Date is within 120 days of Start date
If Yes, End date will remain same
If No, End date will be changed to start date +120 days

For example,
Test excel file date : 25/01/2022
App excel file start date: 19/03/2022
App excel file End date: 19/09/2022

so date is not inbetween the start and end date,
first step: change the start date into 01/03/2022 (1st of the month in which the transaction date (19/03/2022))
second step :change the end date into 01/07/2022 (+120 days from start date(01/03/2022)

2

Hello @lokeshkumar.k

You can use the Modify Date activity to do these calculations and use if activities to check the data conditions.

Thanks