Hi,
select distinct
akun.kodeakun as Kode,
akun.namaakun as nama_akun,
((select sum(debet) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker2}, 'start of month', '+1 month', '-1 day') )
-
(select sum(kredit) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker2}, 'start of month', '+1 month', '-1 day')) ) as September,
((select sum(debet) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker1}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day') )
-
(select sum(kredit) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker1}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day')) ) as Agustus
from akun
left outer join jurnal on jurnal.id_akun = akun.id
where jurnal.tanggal >= {DateTimePicker1} and
jurnal.tanggal <= {DateTimePicker2} and akun.NRCLR = 'NRC'
order by akun.id
Counting from the 1st day of the month to the last day of the month.
If needed from the selected date to the selected date:
select distinct
akun.kodeakun as Kode,
akun.namaakun as nama_akun,
((select sum(debet) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker2}) )
-
(select sum(kredit) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month')
and jurnal.tanggal <= DATE({DateTimePicker2})) ) as September,
((select sum(debet) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker1})
and jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day') )
-
(select sum(kredit) from jurnal
where jurnal.id_akun = akun.id
and jurnal.tanggal >= DATE({DateTimePicker1})
and jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day')) ) as Agustus
from akun
left outer join jurnal on jurnal.id_akun = akun.id
where jurnal.tanggal >= {DateTimePicker1} and
jurnal.tanggal <= {DateTimePicker2} and akun.NRCLR = 'NRC'
order by akun.id