Calculate/Compute the duration between two dates in working days
I'm back for more need in API tricks. Here's my case : because we can't edit the finish date of a task from the API, I need to find a way to make a task end at the date I want. For this, I either have the beginning date of my task, so I just need to find the duration to put in the corresponding field to have my task ending at the finish date I want.
As I work with python, I used the datetime module to get the time difference between the two dates and that's the result of this operation I used to put in the duration field. But of course, you should already think it does not work since the duration in smartsheet is a duration in working days.
From what I see, I do think it would be painful to check for every week-end or holiday that is inside the duration to remove the good amount of days from the duration.
I hope there's a smart way to do it with Smartsheet.
Thank you so much for your time,