Goran Bibic

Goran Bibic

  • 480
  • 2.9k
  • 200.7k

I need to create report for month

May 3 2018 1:32 AM
I need to create report for month

I have created for one day...

Need to repair for mont

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

Answers (1)