How to find START DATE & END DATE of Selected Month

Question

0.00/5 (No votes)

See more:

Hi Friends,

        I have month & Year ( "March" & "2013" ) how can i find first date and last date of this month and Year. ( Like start date - 03/01/2013  & End date - 03/31/2013 )

Posted 2-Mar-13 2:28am

FspFriends

Add a Solution

4 solutions

Solution 1

Possible solution could be

C#

DateTime firstDay = new DateTime(2013, 3, 1);
DateTime lastDay = firstDay.AddMonths(1).AddDays(-1);

but there's quite a couple :)

if you like to use a string

C#

var firstDay = DateTime.Parse("1 March 2013");
var lastDay  = firstDay.AddMonths(1).AddDays(-1);

Posted 2-Mar-13 2:33am

StM0n

Updated 2-Mar-13 2:56am

v2

Comments

FspFriends 2-Mar-13 8:36am

How can i give this line? DateTime firstDay = new DateTime(2013, 3, 1);

I have only MARCH 2013 both are strings

Espen Harlinn 2-Mar-13 8:40am

You're kidding aren't you?

StM0n 2-Mar-13 8:57am

:)

StM0n 2-Mar-13 8:57am

See my improved answer...

Espen Harlinn 2-Mar-13 9:26am

5'ed!

Solution 3

C#

DateTime firstDateOfMonth = new DateTime(year, month, 1);
DateTime lastDateOfMonth = new DateTime(year, month, DateTime.DaysInMonth(year, month));

Posted 2-Mar-13 8:51am

DaveyM69

Solution 4

ASP.NET tag checked, so you may need to resolve problem in SQL query. I recommend you to use stored procedure[^], because it can also improves performance:

SQL

CREATE PROCEDURE GetDataByMonthAndYear
        @iMonth INT,
        @iYear INT
AS
BEGIN
    DECLARE @bDate DATETIME
    DECLARE @eData DATETIME

    SET DATEFORMAT ymd;

    SET @bDate = DATEADD(mm, @iMonth-1,DATEADD(yy, @iYear-1900, '1900-01-01'))
    SET @eDate = DATEADD(dd, -1,DATEADD(mm, 1,@bDate))

    --SELECT @bDate AS [bDate], @eDate AS [eDate]

    SELECT Field1, Field2, Field3, FieldN 
    FROM YourTableName
    WHERE [DateField] BETWEEN @bDate AND @eDate

END

On MS SQL Server 2012 you can use DATEFROMPARTS[^] function to build dates from parts.

Posted 2-Mar-13 9:48am

Maciej Los

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Accepted Answer · 2013-03-02T02:37:00

Solution 2

Heve a look at: DateTime Constructor (Int32, Int32, Int32)[^] and the DateTime.DaysInMonth Method[^]

DateTime start = new DateTime(2013,3,1);
DateTime end = new DateTime(2013,3,DateTime.DaysInMonth(2013,3));

Best regards
Espen Harlinn

Posted 2-Mar-13 2:37am

Espen Harlinn

Comments

Sergey Alexandrovich Kryukov 12-Mar-13 17:13pm

Sure, a 5.
—SA

Espen Harlinn 12-Mar-13 17:28pm

Thank you, Sergey :-D