SQL Server, SSRS and Crystal Reports: Get last day of month

Friday 30 October 2009

Get last day of month - CR

local numbervar thismonth := Month(CurrentDate)+1;
local numbervar thisyear := Year(CurrentDate);
local datevar endday;

endday := Date(thisyear, thismonth, 1)-1; //get the last day of the month

4 comments:

Anonymous said...: thank worked perfect for what I needed.; 16 April 2010 at 19:06
Dom Horton said...: no worries!; 19 April 2010 at 10:30
Anonymous said...: its for vb.net?; 10 February 2011 at 06:05
Dom Horton said...: It's for Crystal Reports. Very similar for VB though:

Local thismonth As Number
Local thisyear As Number

thismonth = Month(CurrentDate)+1
thisyear = Year(CurrentDate)

formula = cDate(thisyear, thismonth, 1)-1; 10 February 2011 at 15:49