APIs as Functions - Provide a Date Difference Function in Chorus BPM

[smsjames]

Add a new function that provides a date difference option
You should be able to choose whether to do a minute/hour/day/month/year function.

This is such a common requirement when building processes and the current approaches being taken by consultants require a ridiculous number of workarounds.

[Karen_Hunter]

I voted up to enhance the Service Design Date Functions palette to include a Date Diff operation.  FYI...  A Generic Offering [PSUtility web service] is available today, as is, with limited Error Handling from Professional Services.  This service accepts a from date, to date, and business/calendar day parameter and returns the number of days/weeks/months/years in its response.  It is not part of the server regression test cycle, but may provide interim relief to address the day/month/year functionality.

[findern]

Thanks for submitting this idea! This is being considered for an upcoming Chorus release.

[doran.george]

One way to find the number of days between two dates.  In this case, it is a RCVD and CURRENT_DATE.  Looking for a date diff greater than 22:

 

Then next IF statement may check for greater than 14, effective creating a range of 22-15 days.