1 2 Previous Next 17 Replies Latest reply on Sep 14, 2016 10:51 AM by SteveMartino

    Variable not passing to Date field in script (FM 12)

    ronniemilsap

      Help is much appreciated.  TIA.

       

      I have a fairly simple script to apply a date range search to records using a defined variable passed from start and end Global date fields to the "Date" field in a "///...///" format.  I'm not well versed in scripting, so please forgive any ridiculous inclusions or redundancy (like "Show all records").

       

      After pressing the "OK" button in the Custom Dialogue, the cursor simply jumps to the following field in the layout ("First Name" field instead of "Date") and pressing enter throws the error "No visitors found for search" when, clearly there should be results.  But since it's not passing the variable data to the proper field, it cannot apply the search.

       

      Here is my script and a few of additional images as well:

       

      Screen Shot 2016-09-14 at 8.04.15 AM.png

      Screen Shot 2016-09-14 at 8.05.38 AM.png

      Result:

      Screen Shot 2016-09-14 at 8.11.00 AM.png

      Layout:

      Screen Shot 2016-09-14 at 7.59.06 AM.png

       

      All records:

      Screen Shot 2016-09-14 at 8.08.57 AM.png

        1 2 Previous Next