Post

2 followers Follow
0
Avatar

Need to calculate "On Time" through API or workflow, using date minimum over a range of entities

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?

Import from old forum Answered

Please sign in to leave a comment.

4 comments

0
Avatar

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.

Clarizen Team 0 votes
Comment actions Permalink
0
Avatar

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.

Import from old forum 0 votes
Comment actions Permalink
0
Avatar

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.

Clarizen Team 0 votes
Comment actions Permalink
0
Avatar

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,

  1. Need to determine how many working days b/w this calc. data and actual end date for milestone.

    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

Import from old forum 0 votes
Comment actions Permalink