Home Forums SQL Server 2005 SQL Server Newbies eed to get previous quarter date from current date RE: eed to get previous quarter date from current date

  • March 19, 2018 at 8:33 am

    #1983763

    Last year:

    (DT_WSTR,4)YEAR(DATEADD("yy",-1,GETDATE()))

    Last Quarter:

    (DT_WSTR,1)DATEPART("qq",DATEADD("qq",-1,GETDATE()))