script between and

 $produk = $_POST['produk'];
      $tanggal_awal=$_POST['tanggal_awal'];
      $tanggal_akhir=$_POST['tanggal_akhir'];
      $sql = "SELECT * FROM trx_incoming WHERE incoming_description = '".$produk."'
       and (incoming_date between ='".$tanggal_awal."' and '".$tanggal_akhir."')" ;

      $query = mysqli_query($koneksi,$sql);