Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rakeshkumar1890
Creator
Creator

Date + 2 business date

Hi Folks

Need your help to getting below OutputDate

IdDate1Date2Date3OutputDate
1003/10/20213/15/20213/24/2021 
1003/10/20213/14/20213/20/2021 
1003/10/20213/13/20213/19/2021 
1003/10/20213/12/20213/19/20213/19/2021
1003/10/20213/11/20213/19/2021 
2002/1/20213/2/20213/31/2021 
2002/1/20213/1/20213/10/2021 
2002/1/20213/1/20213/1/2021 
2002/1/20212/28/20212/28/2021 
2002/1/20212/22/20212/27/2021 
2002/1/20212/15/20212/26/20212/26/2021

 

1. Case Id 100 : Calculate Date1 + 2Business Days and check Date2 and Resultant get corresponding date3 

2. Case Id 200 : Same as above but here 2/1/2021 + 2BD = 2/3/2021 and Date2 this date is not present so look the nearest on first.

 

 

Labels (1)
0 Replies