Date String

• seajoker

  Say Hey Kid

  Points: 700

  More actions

  May 27, 2008 at 2:38 pm

  #207754

  I have this where clause:

  where sales.fld_posting_date between DATEADD(wk, DATEDIFF(wk,0,getdate()-7), 0) and (DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) -1)

  I need to get this same week from last year.

  Any help would be appreciated?

  seajoker

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738150

  More actions

  May 27, 2008 at 3:02 pm

  #820854

  Change the getdate to dateadd(yyy, -1, getdate()

• seajoker

  Say Hey Kid

  Points: 700

  More actions

  May 28, 2008 at 10:58 am

  #821331

  Thanks for the help, it works as I need it to.