How to get the First and Last date of a month

Question

0.00/5 (No votes)

See more:

Hello everyone,

I want to find the first and last date of a month. can anyone help me out how to get it. I have a combobox filled with months i.e. January, February,March,...... and so on. Now what i want is i will select the Month from the combobox, then i should get the first and last date of that month. Can any one help me out in doing so.

Thanks in Advance

Jagdish

Posted 5-Dec-10 17:58pm

Jagdish.rkl

Add a Solution

4 solutions

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)

thatraja · Answer 1 · 2010-12-05T18:12:00

Solution 1

I found this[^] in 1st page of Google[^]. Always hit in search engine before asking here because it's frequent & easy one, You can find this by searching in CP.

Posted 5-Dec-10 18:12pm

thatraja

Comments

Jagdish.rkl 6-Dec-10 0:21am

Thanks a lot. i got it.

Not Active · Answer 2 · 2010-12-05T18:14:00

Solution 2

Well quite obviously the first day of the month is 1 :rolleyes:

The last day can be obtained from Calendar.GetDaysInMonth[^]

Posted 5-Dec-10 18:14pm

Not Active

Comments

Jagdish.rkl 6-Dec-10 0:21am

Thanks a lot. i got it.

Jagdish.rkl · Answer 3 · 2010-12-05T18:24:00

Private Function GetFirstDateOfMonth(ByVal iMonth As Integer)<br />
        Dim dtFrom As DateTime = New DateTime(DateTime.Now.Year, iMonth, 1)<br />
        dtFrom = dtFrom.AddDays(-(dtFrom.Day - 1))<br />
        Return dtFrom<br />
    End Function<br />
<br />
    Private Function GetLastDateOfMonth(ByVal iMonth As Integer)<br />
        Dim dtTo As New DateTime(DateTime.Now.Year, iMonth, 1)<br />
        dtTo = dtTo.AddMonths(1)<br />
        dtTo = dtTo.AddDays(-(dtTo.Day))<br />
        Return dtTo<br />
    End Function

I found the answer for my query so thought of posting it here. we can get the first and last date of a month from these functions.

Maciej Los · Answer 4 · 2010-12-06T08:16:00

To get first and last day of month you can use a little trick with DateSerial() function, like this:

VB

Sub Main()
    Dim fDayOfMonth As Date = Nothing
    Dim lDayOfMonth As Date = Nothing
    Dim i As Integer = 0
    For i = 1 To 12
        fDayOfMonth = GetFirstDayOfMonth(2010, i)
        lDayOfMonth = GetLastDayOfMonth(2010, i)
        Console.WriteLine("first day: " & fDayOfMonth & "; last day: " & lDayOfMonth)
    Next
    Console.ReadLine()
End Sub
Function GetFirstDayOfMonth(ByVal _year As Integer, ByVal _month As Integer) As Date
    Return DateSerial(_year, _month, 1)
End Function
Function GetLastDayOfMonth(ByVal _year As Integer, ByVal _month As Integer) As Date
    Return DateSerial(_year, _month + 1, 1 - 1)
End Function

This should always return good value (date), no matter how many days (28/29) has February.

How to get the First and Last date of a month

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0