1 Reply Latest reply on Jan 17, 2015 9:06 AM by philmodjunk

    Date Range within a script

    JohnMcGlade

      Title

      Date Range within a script

      Post

      I created a script that creates a date range based on todays date and a calculation on today's date.

      I am using the set field function to populate the fields as follows:

      Insert Current Date(Select, Current_date)

      Set Field (Global Start Date = Current date + 1) 

      Set Filed (Global End Date = Current date + 45)

      Set Field (Date_Embark; Global_Start_Date & "..."& Global_End_Date) 

      This final command sets the field to  1/17/2015...3/3/2015, which looks correct, but the system doesn't seem to see this as a date range and returns the response "No records match this find criteria"  There should be many records that match and when I input that same date range into the field, without using the script, it returns the correct records.

      I'd appreciate any ideas on this.

      Thanks

       

       

      Screen_Shot_2015-01-17_at_11.08.16_AM.png