Is it possible to filter Expresso Store 2 orders between two dates in a template? EG the customer wants to see all their orders between 2013 and 2014.

Many thanks

1 Answer 1


You could do this pretty simply with this:

{exp:query sql="SELECT order_hash FROM exp_store_orders WHERE order_completed_date > 1356998400 AND order_completed_date < 1420070400"}
{exp:store:orders order_hash="{order_hash}"}
Order #{order_id}


  • Thanks so much for this was a great (and simple) solution
    – MrTomTom
    Nov 18, 2015 at 2:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.