Find the First and Last Day of the Current Quarter

Tweet

A very handy piece of code by Karl that finds the first and last day of the current quarter.

C#

DateTime datetime = DateTime.Now;

int currQuarter = (datetime.Month - 1) / 3 + 1;

DateTime dtFirstDay = new DateTime(datetime.Year, 3 * currQuarter - 2, 1);

DateTime dtLastDay = new DateTime(datetime.Year, 3 * currQuarter + 1, 1).AddDays(-1);

 

Response.Write("First Day of Quarter - " + dtFirstDay.ToShortDateString() + " : " +

    "Last Day of Quarter - " + dtLastDay.ToShortDateString());

VB.NET

Dim datetime As DateTime = DateTime.Now

Dim currQuarter As Integer = (datetime.Month - 1) / 3 + 1

Dim dtFirstDay As New DateTime(datetime.Year, 3 * currQuarter - 2, 1)

Dim dtLastDay As New DateTime(datetime.Year, 3 * currQuarter + 1, 1).AddDays(-1)

 

Response.Write("First Day of Quarter - " & dtFirstDay.ToShortDateString() & " : " _

& "Last Day of Quarter - " & dtLastDay.ToShortDateString())

Tweet

About The Author

Suprotim Agarwal, Developer Technologies MVP (Microsoft Most Valuable Professional) is the founder and contributor for DevCurry, DotNetCurry and SQLServerCurry. He is the Chief Editor of a Developer Magazine called DNC Magazine. He has also authored two Books - 51 Recipes using jQuery with ASP.NET Controls. and The Absolutely Awesome jQuery CookBook.

Follow him on twitter @suprotimagarwal.