Jump to content

Date filter for shop_orders

Daniel Juhl Kristensen

Recommended Posts

I'm trying to extract a sum of the current dates shop_orders total value.

But the dates in shop_orders are wierd to me, how would you filter them so you for instance only get the orders for the current date or the current week ?

I wanted to use php date function, have it find todays date and just compare it to the dates in the table, but it has a clock aswell, so I need it to ignore half the field ?

Pls. help me :)

Share this post

Link to post
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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More