coba line :
...
where a.barang_jasa = ''B'' and a.tanggal_lpb >= '''||TglAwal| |''' and
a.tanggal_lpb <= '''||TglAkhir| |'''';
diganti menjadi
...
where a.barang_jasa = ''B'' and a.tanggal_lpb between
to_date('''||to_char(tglawal,'yyyymmddhh24miss')||''',''yyyymmddhh24miss'') and
to_date('''||to_char(tglakhir,'yyyymmddhh24miss')||''',''yyyymmddhh24miss'')';
regards,
pandu wp
[Non-text portions of this message have been removed]
