Home Forums SQL Server 2008 SQL Server 2008 - General how to display previous month data along with current month data RE: how to display previous month data along with current month data
@SQLFRNDZ
SSCrazy Eights
Points: 9095
More actions
February 1, 2011 at 1:28 pm
#1281124
If the month is january then how can we display previous month?
use datediff(dd,date,value) function
[font="Tahoma"]--SQLFRNDZ[/url][/font]