Various quarter-related DateTime functions in C#

The DateTime object – or struct – lacks functions for quarters. You can e.g. add minutes, months, days etc. to a date but not quarters.

Here comes a short list of simple quarter-related functions.

Add quarters to a date:

public DateTime AddQuarters(DateTime originalDate, int quarters)
{
	return originalDate.AddMonths(quarters * 3);
}

Example:

DateTime future = AddQuarters(DateTime.UtcNow, 2);

Get the quarter number of a date:

public int GetQuarter(DateTime fromDate)
{
	int month = fromDate.Month - 1;
	int month2 = Math.Abs(month / 3) + 1;
	return month2;
}

Usage:

int quarter = GetQuarter(DateTime.UtcNow);

Get first and last day of a quarter:

public DateTime GetFirstDayOfQuarter(DateTime originalDate)
{			
	return AddQuarters(new DateTime(originalDate.Year, 1, 1), GetQuarter(originalDate) - 1);
}

public DateTime GetLastDayOfQuarter(DateTime originalDate)
{
	return AddQuarters(new DateTime(originalDate.Year, 1, 1), GetQuarter(originalDate)).AddDays(-1);
}

Usage:

DateTime first = GetFirstDayOfQuarter(DateTime.UtcNow);
DateTime last = GetLastDayOfQuarter(DateTime.UtcNow);

View all various C# language feature related posts here.

Advertisements

About Andras Nemes
I'm a .NET/Java developer living and working in Stockholm, Sweden.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

ultimatemindsettoday

A great WordPress.com site

iReadable { }

.NET Tips & Tricks

Robin Sedlaczek's Blog

Developer on Microsoft Technologies

HarsH ReaLiTy

A Good Blog is Hard to Find

Softwarearchitektur in der Praxis

Wissenswertes zu Webentwicklung, Domain-Driven Design und Microservices

the software architecture

thoughts, ideas, diagrams,enterprise code, design pattern , solution designs

Technology Talks

on Microsoft technologies, Web, Android and others

Software Engineering

Web development

Disparate Opinions

Various tidbits

chsakell's Blog

Anything around ASP.NET MVC,WEB API, WCF, Entity Framework & AngularJS

Cyber Matters

Bite-size insight on Cyber Security for the not too technical.

Guru N Guns's

OneSolution To dOTnET.

Johnny Zraiby

Measuring programming progress by lines of code is like measuring aircraft building progress by weight.

%d bloggers like this: