Post reply

GETDATE -1 Expression

  • February 16, 2009 at 7:49 am

    #134809

    I have a exspression which I use to get the current date including the file name:

    "Process completed successfully for " + (DT_STR, 4, 1252) YEAR

    ( GETDATE()) + "-" + RIGHT("0" + (DT_STR, 2, 1252) MONTH( GETDATE

    ()), 2) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DAY(GETDATE() ), 2)

    How would I change this to get yesterdays date?

    i.e. GETDATE() -1

    Thanks

  • February 16, 2009 at 8:04 am

    #944561

    ...DATEADD( "Day", -1, GETDATE() )

    --Ramesh

  • February 16, 2009 at 8:09 am

    #944570

    Or DATEADD("d",-1,GETDATE())

    (I forgot that SSIS needs the quotes).

    Derek

  • February 16, 2009 at 8:28 am

    #944588

    Thanks Guys,

    Im how would the whole exspresion look?

    In regards to my code posted abouve?

  • February 16, 2009 at 8:38 am

    #944605

    ...Just need to replace GETDATE() with DATEADD( "Day", -1, GETDATE() ) in the expression

    --Ramesh

  • February 16, 2009 at 8:45 am

    #944615

    "Process completed successfully for " + (DT_STR,4,1252)[YEAR]([DATEADD]("d",-1,[GETDATE]())) + "-" +

    ("0" + (DT_STR,2,1252)[MONTH]([DATEADD]("d",-1,[GETDATE]())),2) + "-" +

    ("0" + (DT_STR,2,1252)[DAY]([DATEADD]("d",-1,[GETDATE]())),2)

    Derek

  • February 16, 2009 at 8:56 am

    #944625

    thanks Derek, worked well!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy