AnsweredAssumed Answered

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

Question asked by ronniemilsap on Sep 14, 2016
Latest reply on Sep 14, 2016 by SteveMartino

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

Outcomes