Date Function

[bxgirl]

I'm interested in getting the 1st day and last day of the previous month. Is there a function that does this or will I need a combination of functions?

Thanks.

 

[vongrunt]

-- first day of prev month
select dateadd(mm, datediff(mm, 0, getdate())-1, 0)

-- last day of prev month
select dateadd(mm, datediff(mm, 0, getdate()), -1)

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[bxgirl]

Thank you!!!