Saved Search to get Sales orders created in last one Hour.

Create Saved Search of type Transaction
Under the Criteria tab > Standard subtab:

Type = is Sales Order
Add Formula (Numeric) Field

In formula column Enter: (TO_DATE(TO_CHAR({today},’MM/DD/YYYY HH24:MI:SS’),’MM/DD/YYYY HH24:MI:SS’)-TO_DATE(TO_CHAR({datecreated},’MM/DD/YYYY HH24:MI:SS’),’MM/DD/YYYY HH24:MI:SS’))*24

Description : less than or equal to 1
Click Save.

Leave a comment

Your email address will not be published. Required fields are marked *