Need to determine if custom field date1, plus duration x, is a date less than some other final custom date.
I can't use customization workflow since date1 is calculated as the minimum date across a range of entities.
I am using the API and need a way to account for working days and calendar exceptions...etc.
Does anyone have any suggestions for me?
Is there is a dateadd or datesubtract function available from the API?
Please sign in to leave a comment.
The API does not provide Date math functions.
What you might be able to do is create a custom field which does all the needed clculations for you using the built in functions to add dates and then when querying those items via the API find the relevant item by scanning this new custom field.
Are you saying that I can use the customization API to find some min/max date among child or related records for some given entity?
I have not found anything that supports these type of calculations.
No, i was suggesting that you perform some of the calculations within Clarizen (using customizations) and then find the min\max using API (Altough there is a chance that our roillup fields can help you achieve what you're trying to do using customizations only).
In any case, I suggest you simply describe exactly what you're trying to acieve and we'll find the best way to implement that.
Scenario
1.we have a custom field for earliest executable among tasks.
2.we use api to calculate the min of these across a milestone's tasks,
currently removing Sat., Sunday.
need to account for organization exceptions like holidays
option 1 - push the min. date back to anther clarizen custom field.; then use customization workflow rule to calculate to account for working days
option 2 - ??
Roxy