Hi all,

The statement

select dateadd(month, -1 , convert(datetime, '30-SEP-1996&#39
return Aug-30-1996.

but I want to get the last day of the month. (ie AUG-31-1996)
for example
select dateadd(month, -1 , convert(datetime, '30-SEP-1996&#39
I want MAY-31-1996 to return NOT MAY-30-1997.

Thanks in advance for your help
Tung Nguyen