Prakash (12/3/2007)
Dear All,I want to get the records created in a particular week.
if i pass 3/12/2007 i want to get the records created in that week
You could use :
datepart(wk, '3/12/2007')*53 + datepart(yyyy, '3/12/2007')
The first part gives you the week number in that year, the second part the year.
If the year is not needed (you have only data for the current year), then just use : datepart(wk, '3/12/2007')
Regards,
Andras