動的SOQLで日付け型を条件に指定する場合

 WHERE DATEVALUE(CreatedDate) >= 1999-11-01 AND DATEVALUE(CreatedDate) < 1999-12-01

System.UnexpectedException: Invalid aggregate function: DATEVALUE

WHERE CreatedDate >= 1999-11-01 AND CreatedDate < 1999-12-01

System.QueryException: value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes

参考

• 【Apex】動的SOQLのWHERE句で日付を指定する方法は？ - セールスフォースお助け隊ブログ | Salesforce

WHERE CreatedDate >= 1999-11-01T00:00:00Z AND CreatedDate < 1999-12-01T00:00:00Z