Devart Forums

Posted: **Wed 09 Sep 2020 11:08**

I have the following WHERE:

    WHERE YEAR(entries.timestamp) = YEAR(CURRENT_DATE()) AND MONTH(entries.timestamp) = MONTH(CURRENT_DATE())

If I do anything on the query builder, this gets rewritten to:

WHERE YEAR(CURRENT_DATE(), MONTH(entries.timestamp) = MONTH(CURRENT_DATE()))

Which is not right. Why?

Posted: **Wed 09 Sep 2020 20:23**

We will fix it in one of the next product builds.

WHERE section gets messed up