AnsweredAssumed Answered

ExecuteSql Select query

Question asked by tobyc on Aug 2, 2018
Latest reply on Aug 2, 2018 by user19752

Hi everyone, I'm currently using FM17 and my question is how do I select  just by months with Execute Sql? Not as simple as Perform Find/ Find Mode.

Sales date format is DD/MM/YYYY.

 

For Example

ExecuteSql( "select count('ID') from Sales where Status = ? and Sale_Date = ? "; "" ; "" ; "Complete" ; "*/02/2018")

 

TIA

Outcomes