Discussion board where members can get started with QlikView.
I have a field called Target date
Based on this date I need to calculate 3 more dates,
executed date - 60 days prior to Target date
· Approved date - 7 days prior to executed date
· Selected date - 45 days prior to Approved date
Here based on 10/10/2017,
Executed date would be - 8/10/2017
Approved date would be - 1/10/2017
Selected date would be - 11/15/2016
How can I acheive this ?
Hi Try this.
Date(TargetDate -60) for Executed Date
Date(TargetDate -60 - 7) for Approved Date
Date(TargetDate -60 - 7 - 45) for Selected Date
View solution in original post
date(num([Target Date])-60) as [Execute Date],
date(num([Target Date])-67) as [Approved Date],
date(num([Target Date])-112) as [Selected Date],
Thank you @kaushiksolanki
I used the belwo script and that worked.
Date(TargetDate -60) as Executed Date
date(Date(TargetDate -60 )- 7) as Approved Date
date(date(Date(TargetDate -60 )- 7)- 45) as Selected Date
Kindly mark answer as correct.