Loading

I need to create report for month

Goran Bibic

8y684SQL

I need to create report for month

I have created for one day...

Need to repair for mont

Some help

select datum as Datum, SUM (Try_Convert(float,[iznos_sa_pdv])) as UKUPNO
from mp_kasa_lista
where [datum] >= CONVERT(datetime, convert(varchar(10), GETDATE() ,120), 120)
AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120)) and tip_placanja='Virman'
group by datum

1 Reply

Know the answer? Post it — somebody with the same question will find it here.