Script for between two dates AND Null field
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)]
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?