$where{$colname}{'-between'} = [$from,$to]; #my code
where{completion_date}{-not_between}= ['2002-10-01', '2003-02-06'];#your code