Skip to main content

Posts

Showing posts from December, 2008

SSRS Dates Calculation

First Day of Current Month: =cdate( month(today) & "/1/" & year(today) ) Last Day of Current Month: =cdate( month(today) & "/" & day(dateadd("d", -1, dateadd("m", 1, cdate(month(today) & "/1/" & year(today))))) & "/" & year(today) ) First Day of Next Month: =cdate( month(dateadd("m", 1, today)) & "/1 /" & year(dateadd("m", 1, today)) )