Date Help

[mahitham]

Hi Experts,

Can any one please help me on below requirement. I have a [Actual Date] field in Time stamp format.

I have converted Time stamp to normal format by Date(floor([Actual Date])) as [Actual Date]

Requirement:

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.

[mahitham]

HI @Channa 

Thanks for your reply. Could you please share some sample app with holidays exclusion through variable.

I have a doubt here how we will pass future years holidays before dynamically.

Please help me on this.

[Channa]

check the screen it is excluding 2 holidays..6 saturdays ,6 sundays and 2 holidays

soo u get 33

to over come this add all your public holidys into variable

[mahitham]

Hi @Channa 

Thanks for your continuous help. Its working.

As you said I have created a variable called vDate and passed the holiday dates like below. But it looks static.

My only concern is in coming year like 2020 how the app will be updated with holidays in this variable.