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.
ExecuteSql( "select count('ID') from Sales where Status = ? and Sale_Date = ? "; "" ; "" ; "Complete" ; "*/02/2018")