Getting Current Monthend

this should do:

select dateadd(day, -1,dateadd(month, 1,convert(datetime,convert(varchar(8),  your_date_field , 120) + '01',120)))

Select allOpen in new window

sorry but I think my date is a string '20080429'

if I just run this part  select dateadd(day, -1,dateadd(month, 1,'20080429'))

it returns

2008-05-28

note: if you want to get a "date range" query to include up to the last day of the month, it should best be something like this, doing a < of the first of next month:

select ...
where yourfield < dateadd(month, 1,convert(datetime,left('20080429',6) + '01',112))

Select allOpen in new window

thank you!