5 Replies Latest reply on Sep 13, 2016 1:03 PM by dgant@804technology.com

    Scripting a date range - getting errors...


      Trying to write a script to search for a date range, 10 days on either side of our current date in a single field.  This is what I am scripting and I will also list the error I am getting. Layout is “Weekly Follow Up” and field is “Follow Up Date”.


      Go to Layout [“Weekly Follow up” (Requirements)]

      Go to Find Mode [pause]

      Enter Calculated Result


      Then entered this string

      [Requirements::Follow Up Date ; "GetAsText(Get(CurrentDate) - 10) & "..." & GetAsText(Get(CurrentDate) + 10) "]


      Getting the error

      “an operator (eg. +,-,*,…) is expected here.


      If I use the “go to targeted field” mode and then enter the calculated result

      "GetAsText(Get(CurrentDate) - 10) & "..." & GetAsText(Get(CurrentDate) + 10) "]



      I get the error

      “this number cannot be evaluated”


      Can anyone see my error with this script.