AnsweredAssumed Answered

SQL; using Month() in WHERE statement

Question asked by Siroos Jafary on Mar 5, 2018
Latest reply on Mar 22, 2018 by Siroos Jafary

Hi all,

 

How can we use functions like Month() or Day() in "WHERE" statement of SQL?

 

Like:

 

ExecuteSQL(

"SELECT Sum( myTotal )

FROM myTable

WHERE Month(CreationDate) >= ?";

"";

"";

$month)

 

Any advise is appreciated.

Outcomes