We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Leaderboard


Popular Content

Showing most liked content on 03/10/2017 in all areas

  1. 1 point
    There 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".
  2. 1 point
    Sorry, "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
×