Junior

route217

<div>
<div class="content wysiwyg-content fr-view">
Hi Experts<br><br>How would you amend the following And clause so we have only todays sales; So assume Monday 17.05.21 Sales Starts at 00:00:00 and end 23:59.59 - likewise1 second later we start to capture Tuesday's sales and so on<br><br>Current SQL AND Statement<br>And `sales_flat_order`.`created_at` &gt;= date_add(<strong>CURDATE()</strong>,interval -DAY(CURDATE())+1 DAY)<br><br><br>
</div>
</div>



Hi Experts
How would you amend the following And clause so we have only todays sales; So assume Monday 17.05.21 Sales Starts at 00:00:00 and end 23:59.59 - likewise1 second later we start to capture Tuesday's sales and so on
Current SQL AND Statement
And `sales_flat_order`.`created_at` >= date_add(
CURDATE()
,interval -DAY(CURDATE())+1 DAY)

Amend and Clause to only show today's Data

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Sales

We're obsessed with building an excellent product, and our goal is to create a tool that people will love to use—one that’s fast, beautiful, responsive, and makes your life easier. The only thing we love more than our product is our customers. The incredible teams that use our product are the most important thing to us, and we're here to provide support to them 24/7.