report order dates

Not easily; would require extra joins. Post_date is more accessible since its in the posts table.

Hello Mike,

Ok but the logical in reports is that use _complete_date cause, i have orders that make time to be completed. some times more than one month. I create one order, and it is completed some month later.

So the report are not real cause customer pay when order is completed.

Thanks.

_complete_date is when the order is completed/shipped. Not paid.

its true. but it is more near to the paid status.

status by default go from “pending payment” to “completed order”.

If not another solution could be to get the dates of the orders which are actually paid

As I said, not easily. This will be more feasible when we move to custom tables. https://github.com/woothemes/woocommerce/issues/10071

Instead of _completed_date, you could use _paid_date though.
Yes, I see why it’s more difficult. But I do think Louis has a point in that for the reports it makes much more sense to use the paid date than the order date.