Discussion board where members can get started with QlikView.
I have the Actual Date field like below in the attached QVD.
Could you please help me to add 35 business days.
I have null values also in Actual Date for those need to skip business days adding.
Now from this [Actual Date] I need to derive a New field called [Estimate Date] like below i.e.,
Value of [Actual Date] field + 35 business days
A “business day” is defined as any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.
Please help me on this.
Thanks in advance
View solution in original post