Home Forums Data Warehousing Integration Services expression yyyymm with mm-1 RE: expression yyyymm with mm-1

  • July 28, 2014 at 7:11 am

    #1732823

    Shanmuga Raj (7/28/2014)

    In My derived column I want expression for getting yyyymm ( where mm is mm-1)

    Expression in Derived Column

    (DT_STR,4,1252)DATEPART("yyyy",GETDATE()) + RIGHT("0" + (DT_STR,2,1252)DATEPART("mm",GETDATE()),2)

    Result : 201407

    Expected Result : 201406

    Try this:

    (DT_STR,4,1252)DATEPART("yyyy",DATEADD("Month",-1,GETDATE())) + RIGHT("0" + (DT_STR,2,1252)DATEPART("mm",DATEADD("Month",-1,GETDATE())),2)