SOQL查询要整整一个月，除了上周

Question

我想查询一个月的记录，除了那个月的去年。 我的SOQL查询是这个

select id,name from opportunity where CreatedDate=THIS_MONTH And WEEK_IN_MONTH IN (1,2,3)

SOQL查询以获取整个月，除了上周。

Answer 1

您将其标记为Apex，所以您可以作弊吗？

Date today = System.today();
Integer cutoff = Date.daysInMonth(today.year(), today.month()) - 7;

System.debug([SELECT Id
    FROM Opportunity
    WHERE CreatedDate=THIS_MONTH AND DAY_IN_MONTH(CreatedDate) < :cutoff]);