Expand my Community achievements bar.

How to add 5 Weekdays to a date field using fusion

Avatar

Level 3

Good morning. I am trying to use fusion to set a date on a date field that is 5 days from "now" using addDays(now;5) but it keeps counting the weekends. I would like to skip the weekends and only add 5 WORK days, but addWorkDays(now;5) is not working. Any ideas?

 

Thanks in advance.

2 Replies

Avatar

Level 9

Hello Ronald,

 

unfortunately there is no addWorkDays() function in Fusion.

 

Perhaps you will find a solution on basis of the attached blueprint. That scenario will provide you with the weekdays days between two given dates...

 

Regards

Lars

Avatar

Level 3

Thank you for this information. I was able to devise a workaround using a calculated field on the request issue that does the same thing I was trying to do in Fusion (addWorkDay) and then had Fusion reference that field when setting the project level custom form field.

 

Thanks again.