Connection Manager Properties

• tom 100

  SSC Rookie

  Points: 28

  More actions

  May 16, 2013 at 8:56 am

  #272692

  Hi,

  I need some assistance in adapting this connection string expression to retrieve the previous day rather than the current day- GETDATE -1

  @[Dest_Dir] + "\\" + (DT_WSTR,2)DatePart("DD", GetDate()) + RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2) + RIGHT("0" + (DT_WSTR,4)DatePart("YYYY", GetDate()), 2) + "FX.csv"

  Thanks in advance

• Ness

  SSCarpal Tunnel

  Points: 4282

  More actions

  May 16, 2013 at 9:10 am

  #1615857

  You should be able to use GETDATE()-1 of you are not worried about the time of day. If that does not work look at ...

  in SQL - select CONVERT(DATETIME, DATEDIFF(dd, 0, DATEADD(dd, -1, GETDATE())))

  so for your use maybe just DATEADD(dd, -1, GETDATE())

  SQL DBA
  Every day is a school day, and don't trust anyone who tells you any different.
  http://sqlblogness.blogspot.co.uk