Thank you for reply
yes there are more orders from 12 am to 7 am
and i need to show it with date start
the order start in 31/03/2015 8 pm and finish 7 am
so that the following statement retrieve only today
WHERE DATEDIFF(d,dbo.[Jeddah-Live$Sales Line].[Shipment Date],GETDATE()) = 0
how to change this statement to accept next day until 7 am if possible