Get the previous month's first and last day dates in c#

c# .net datetime date
Jeremy Boyd picture Jeremy Boyd · Feb 26, 2009 · Viewed 156.7k times · Source

I can't think of an easy one or two liner that would get the previous months first day and last day.

I am LINQ-ifying a survey web app, and they squeezed a new requirement in.

The survey must include all of the service requests for the previous month. So if it is April 15th, I need all of Marches request ids.

var RequestIds = (from r in rdc.request 
                  where r.dteCreated >= LastMonthsFirstDate && 
                  r.dteCreated <= LastMonthsLastDate 
                  select r.intRequestId);

I just can't think of the dates easily without a switch. Unless I'm blind and overlooking an internal method of doing it.

Answer

andleer picture andleer · Feb 26, 2009 
var today = DateTime.Today;
var month = new DateTime(today.Year, today.Month, 1);       
var first = month.AddMonths(-1);
var last = month.AddDays(-1);

In-line them if you really need one or two lines.

Related questions

Difference between System.DateTime.Now and System.DateTime.Today

Can anyone explain the difference between System.DateTime.Now and System.DateTime.Today in C#.NET? Pros and cons of each if possible.

Read More
Convert DateTime to Julian Date in C# (ToOADate Safe?)

I need to convert from a standard Gregorian date to a Julian day number. I've seen nothing documented in C# to do this directly, but I have found many posts (while Googling) suggesting the use of ToOADate. The documentation on …

Read More
End of month calculations

Just wondering if any know of an elegant solution for the following. If I have 30 June 2009 and I add a month I want it to go to 31 July 2009, not the 30 July 2009. This logic is based on the fact that the 30 …

Read More