Confiform date excluding weekends (sat and sund)

Question

Hi,

I have created a form to set a target date from its assigned date.

But I can't able to exclude weekend in that formula as i want just business days to be calculated.

I have created fields with assignedDate and targetDate

With the help of definition rules set the target after 21 days

But it is including sat and sunday.

I want to exclude sat and sunday please help me.

Formula :-

TargetDate=([entry.assigneDate.timestamp] +1814400000)

Tom Stocki · Answer

I have the same issue as requested here. Do you have an update on the solution for calculating only business days?

Russ Seligman · Answer

I have the same issue as requested here. Do you have an update on the solution for calculating only business days?

Alex Medved _ConfiForms_ · Answer

Hi

Sorry to say, but at the moment ConfiForms does not have any built-in functions to help you with handling "business days"

I have added this as a feature request to our internal Jira

Alex