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

    Scripting a date range - getting errors...

    dgant@804technology.com

      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.