Confiform date excluding weekends (sat and sund)

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)

1 answer

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Like • Tom Stocki likes this

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.