Selecting date before 6 months

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  June 17, 2010 at 3:34 am

  #387176

  Hi,

  i want select date which is before 6 month from todays date in parameter property of reporting.Can anybody tel me how to do this?

  Please give me reply asap.

• Lowell

  SSC Guru

  Points: 323518

  More actions

  June 17, 2010 at 6:17 am

  #1181494

  in TSQL, you'll want to use the DATADD function. when you add a negative number, it subtracts it from the date: you can use it to add or subtract any period of time: years/months/days etc

  SELECT

  getdate() as TodaysDate,

  DATEADD(mm,-6,getdate()) as Date6MonthsAgo

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!