using date

[pieandpeas]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

[sourabhmca]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

hi,

select <<items_column>> from <<tablename>> where convert(char(10),date,101) between convert(char(10),getdate()-30,101) and convert(char(10),getdate(),101)

[ck9663]

I'd like to return items where the date column in a database e.g - (12/08/2007 08:16:00) is less than 30 days from the current date

any help would be great

try:

select * from mytable where datediff(dd, datefieldonyourtable, getdate()) < 30