Proposed New Functions

Below are some new functions which have already been proposed...

1. Working Days between Dates -function calculates days between given dates excluding list of holidays and weekends.

2. Capture Text Match(es) -when an external list of terms/text items is submitted for matching to an internal target text column, the function records the term or terms (tokenized) from the input list that were matched within the text of the target column. (submitted by Amr Hassan- Segmetrix)

3. Date/Time Bucketing- set of functions  (e.g. @Year, @Month, @Day, @Hour, @Minutes, @Seconds) that examine a target Date/Time field and return a Category field value for the Year, Month, etc. using specified values/format options for the Categories. 

4.  MillisecondsToDate converts date values in millieseconds to a date value. First argument is the date value, second argument is the custom format for displaying date information.

-----------------------------------

To propose a new function, or refine an existing or proposed function, please contact us