2 Replies Latest reply on Sep 19, 2013 4:59 PM by JeromeSimons

    Using variables to find a range of dates in script, returns error message

    JeromeSimons

      Title

      Using variables to find a range of dates in script, returns error message

      Post

           Dear All:

           I am trying to write a script that takes two values (stored in some unrelated table) and converts those to dates using the values as the year and stores them in variables. I then try to use those variables to search records for a range of dates. Unfortunately, the variables seem to be misinterpreted and the find request returns an error message.

           I inferred already that FM seems to treat dates as quasi-text data types. So I am using quotation marks to sandwich the date expressions.

           I am attaching a screenshot that displays the script so that it becomes easier to judge what is going on here.

           I would greatly appreciate your help.

           Kind regards,

           Jerome

      failingscript.jpg