1 likeThere can be a big difference between how many times a keyword comes up as a pattern match and how many times a keyword comes up as a word. Consider for example the following sentence: Bob the nabob went home to eat kabobs and watch the skibobbing competition. Using PatternCount() will return 4 occurrences of the pattern "bob" - while a custom function such as CountWordOccurrences() will detect only 1 occurrence of the word "bob".
1 likeSorry, "nested functions" (if one is an aggregate) do not seem to work well in eSQL. try this: Let ( [ $query = " SELECT MIN(checkins.date_due) FROM checkins WHERE checkins.id_contact=? AND checkins.isComplete=0" ; $result =ExecuteSQL ( $query ; "" ; "" ; id ) // returns yyyy-mm-dd ]; If ( $result ≠ "?" ; Let ( [ $y = Left($result; 4) ; $m = Middle($result; 6; 2) ; $d = Right($result; 2) ]; Date($m;$d;$y ) ) ; "?" ) )
This leaderboard is set to Los Angeles/GMT-07:00