Saved Search to Show Orders Shipped on a Specific Day

1. Navigate to Reports > Saved Searches > All Saved Searches > New

2. Select Transaction link

3. Set the following under Criteria tab > Standard subtab:

•         Type = Sales Order

•         Formula (Numeric) || Click on formula and type the following formula;

     CASE WHEN to_char({shipdate},'DAY') like '%MONDAY%' THEN 1 ELSE (CASE WHEN to_char({shipdate},'DAY') like '%WEDNESDAY%' THEN 1 ELSE 0 end) end

     Under Formula Numeric column choose equal to 1

 

4. Under Results tab > Columns subtab, add following fields(choose other based on your preference:

•         Formula (Text) || Click on formula and type the following formula

           to_char({shipdate},'DAY')

  5. Enter a Search Title

   6. Click Save & Run