SELECT sum(somefield)
  FROM table
  WHERE datefield BETWEEN ? AND ?