Jump to content

Query to get orders delivered with delay


DARKF3D3

Recommended Posts

Hello,

there's someone that can help me create a query to get order shipped between a data range that has been delivered in more than 5 days?

I need to be able to set the dates and number of days, than the query should look at at all the orders set to shipped between that range and calculate number of days passed until the order has been set to delivered status.

As output i need order id, date shipped, date delivered, number of days, tracking number

Hope you can help me.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...