Home Forums Reporting Services SSRS 2012 Group by Month RE: Group by Month
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 19, 2017 at 9:11 am
#1959959
I would convert all the dates to the first of each month and group on that value. No parsing and concatenating of values required.
dateadd(month,datediff(month,0,Datecol),0)