cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

A date field to should let user to choose only business days on the form

Jump to solution

Hi Team,

I have a requirement and I need help in building a formula.

I have a field called Preferred Dead line ( date field) , where user cannot  enter a date below 5 days from today( the day whenever the user submitted the form).

I have created the rule ( using Datediffdays function)  and it is working fine, the problem is it should not include weekends 

For example if user enter the request on Thursday the calculation for the 5 days will be Thursday, Friday, Monday, Tuesday, Wednesday. So the user should not enter any of those days before / on Wednesday.

I hope I explained it clearly.

Any help much appreciated!

Thanks in Advance!!!

Labels: (1)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: A date field to should let user to choose only business days on the form

Jump to solution

Vadim Tabakman‌ provided a pretty solid write-up for Business Days Validation for Forms.  This seems to be what you are trying to accomplish. Let us know if this covers your question.

Reply
Workflow Hero

Re: A date field to should let user to choose only business days on the form

Jump to solution

Hi Dan,

It worked like a magic !!!

Thanks a lot

Reply