cancel
Showing results for 
Search instead for 
Did you mean: 
smsjames
Staff
Staff

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.

3 Comments
Karen_Hunter
Staff
Staff
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
Staff
Staff
Thanks for submitting this idea! This is being considered for an upcoming Chorus release.
doran.george
Staff
Staff

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.