• If the month is january then how can we display previous month?

    use datediff(dd,date,value) function

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]