AnsweredAssumed Answered

Script for between two dates AND Null field

Question asked by GuyDavis on May 10, 2013
Latest reply on May 10, 2013 by GuyDavis

Title

Script for between two dates AND Null field

Post

     So, I'm getting the hang of this (Thanks again guys! :D).  Here's what I'm looking for:

     (In normal Find Mode) date_ship is between today and 40 days ago AND tracking_outbound_1 is blank.

     Here's my script:

     Go To Layout["Outbound Exception Report" (EVENTS)]

     Enter Find Mode []

     Set Field [EVENTS::date_ship; Get (CurrentDate)-40 & "..." & Get(CurrentDate)]

     New Record/Request

     Set Field [Events::Tracking_outbound_1; " "]

     Perform Find []

     Sort Records [Restore;No dialog]

     Enter Browse Mode []

     Show/Hide Toolbars [Show]

      

     It's pulling the dates right, but I'm getting the records with tracking numbers in the outbound field... Any ideas?

Outcomes