Sales Orders by Date Range

Custom SQL query (hide)

SELECT
  so.num            AS "Order #",
  so.dateIssued     AS "Date Issued",
  customer.name     AS "Customer",
  so.customerPO     AS "Customer PO",
  so.statusId       AS "Status",
  so.totalPrice     AS "Total",
  so.salesman       AS "Salesman"
FROM so
JOIN customer ON so.customerId = customer.id
WHERE so.dateIssued BETWEEN :start_date AND :end_date
ORDER BY so.dateIssued DESC

Query parameters

start_date

end_date

Edit SQL