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 'Virman' group by datum

Try this select datum as Datum, SUM (Try_Convert(float,[iznos_sa_pdv])) as UKUPNO from mp_kasa_lista where month([datum])=month(getdate()) and year(datum)=year(getdate()) group by datum

Answer

I need to create report for month

Goran Bibic

454

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