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

  • 28 December 2017
  • 2 replies
  • 5 views

Badge +5

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!!!


2 replies

Userlevel 5
Badge +8

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.

Badge +5

Hi Dan,

It worked like a magic !!!

Thanks a lot grin.png

Reply