Hi All! I am trying to play around with a test search in Netsuite, where I need to add some special criteria: need to filter sales orders where the sales order dispatch date is different from the related Item fulfillment dispatch date. The criteria tab on the search only allow me to filter for specific date, which is not what I want and need. Any ideas on how to do this? Thank you

Formula numeric : CASE WHEN {date1 field} = {date2 field} THEN 1 ElSE 0 END Equal to 0. First filter out transaction type and mainline. Find a sales order for which you know it's different. Put its internal id in the filter. And keep working on the formula until you figure it out.