AnsweredAssumed Answered

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

Question asked by JeromeSimons on Sep 19, 2013
Latest reply on Sep 19, 2013 by 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

Outcomes