var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date function dilemma
Can anyone tell me how to caluculate the last day of the prior month using getdate() ?
The function will be hardcoded in a query that will run on either of the 1st 7 days of the month - Specifically the the 1st through the 7th day of the following month, for every month of the year.
Thanks in advance for any help.
select dateadd(dd,-1,dateadd(mm, datediff(mm,'20000101',getdate()),'20000101'))