[Message Deleted]

[Member 3879881]

[Message Deleted]

[soni uma]

Try using DateDiff function DATEDIFF(day, pubdate, getdate()) :cool:

[flash665]

like this select datediff(d,'2007-08-08',getdate()) 2007-08-08 is old date getdate is new date

I love li li huang , ha ha , but you don't who is she!

[Colin Angus Mackay]

Don't delete your question - It is rude!

Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

[Paul Conrad]

Geeze, one of those :rolleyes:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon