DATES

[Guest_imported]

I need to run a query to get results for a field for last 12 months. I am using getdate and DATENAME. But I am having problem converting Int TO VarChar.Besides how do I do a While for 12 months? PLs Suggest.

 

[MalcolmW]

Why DATENAME and not DATEPART?<br>Note that GETDATE() returns a time value as well, so either convert it to a string to drop the time or be aware that you are checking for dates between datetime values. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>