3 Replies Latest reply on May 10, 2013 10:22 AM by GuyDavis

    Script for between two dates AND Null field

    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?