select only month and year from Datetimepicker

Question

1.00/5 (1 vote)

See more:

VB

how to select only month and year from datetimepicker in vb.net

Posted 1-Nov-11 23:10pm

meghvarsha

Updated 26-Nov-20 23:36pm

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)

Mehdi Gholam · Answer 1 · 2011-11-01T23:17:00

Solution 1

Date pickers return a DateTime object which has Month and Year properties.

Posted 1-Nov-11 23:17pm

Mehdi Gholam

Prerak Patel · Answer 2 · 2011-11-01T23:18:00

Solution 2

Use Format property.

C#

dateTimePicker1.Format = DateTimePickerFormat.Custom
dateTimePicker1.CustomFormat = "MMMM yyyy" 'or whatever you want

Ref: http://msdn.microsoft.com/en-us/library/system.windows.forms.datetimepicker.format.aspx[^]

Posted 1-Nov-11 23:18pm

Prerak Patel

Paul M Cohen · Answer 3 · 2014-11-02T10:52:00

Solution 4

Solution 2 and 3 will crash with an OutOfBounds Exception if the Value has a date which is greater than the number of days in the Next/Previous month and the user changes month using the arrow buttons. For Example when the Value is 10/31/2014 and the control displays October, 2014. When you change the Month to September the Value is set to 9/31/2014 which is an invalid date and causes an exception.

A workaround is

VB

Private Sub SalesDatePicker_ValueChanged(sender As Object, e As EventArgs) Handles SalesDatePicker.ValueChanged
    If SalesDatePicker.Value.Day <> 1 Then
        SalesDatePicker.Value = DateSerial(SalesDatePicker.Value.Year, SalesDatePicker.Value.Month, 1)
    End If
End Sub

Posted 2-Nov-14 10:52am

Paul M Cohen

Comments

CHill60 2-Nov-14 16:55pm

Interesting! Have you considered fleshing this out and posting it as a Tip?

Paul M Cohen 2-Nov-14 18:02pm

I have never done a tip what does it involve. I have a working solution it would be easy to extract.

CHill60 4-Nov-14 12:45pm

Go to the Articles section...you'll find inductions there... Sorry I'm using my phone for this and it's not easy to post links... Or type :-)

Paul M Cohen 4-Nov-14 14:16pm

Thanks I submitted a tip that should be posted shortly.

qulaitks 8-Sep-19 23:40pm

Good morning
I am having this problem when trying to assign last day of the month.
SalesDatePicker.Value = DateSerial(SalesDatePicker.Value.Year, SalesDatePicker.Value.Month, 1).Addmonths(1).AddDays(-1).

Bhatt Aniruddh · Answer 4 · 2011-11-02T02:53:00

Solution 3

select datetimepicker ---> goto property

format=custom and
CustomFormat=MMM/yyyy

Posted 2-Nov-11 2:53am

Bhatt Aniruddh

Comments

fjdiewornncalwe 2-Nov-11 9:54am

Please don't post duplicate answers.