June 17, 2010 at 3:34 am
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.
June 17, 2010 at 6:17 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply