how to find 3days before date from prasent date

• dastagirid

  SSCommitted

  Points: 1810

  More actions

  November 4, 2009 at 9:44 pm

  #139834

  hi..

  I need three day back date from prasent date.

  example:today date : getdate()

  3 days beforedate=02-11-2009

  is there any function for this.

  Thanks
  Dastagiri.D

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  November 4, 2009 at 10:15 pm

  #1075144

  Yes there is... please see DATEADD in Books Online. Yeah... you could just subtract 3 from a DATETIME datatype, but that won't work on some of the new DATE datatypes from what I understand.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  November 4, 2009 at 10:18 pm

  #1075145

  You could try:

  SELECT DATEADD( dd, -3, GETDATE() )

  And you might look into:

  Common Date Routines

  CEWII

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  November 4, 2009 at 10:21 pm

  #1075147

  Looks like Jeff was a little faster than I..

  CEWII