How do I get the last day of the month using datetimepicker

Question

0.00/5 (No votes)

See more:

Good day

I am a beginner to vb , I am trying to get the last day of the month using the datetimepiker. When i use the up-down control i receive an error ( 'Year, Month, and Day parameters describe an un-representable DateTime.) when month days are not match (31 or 30). I have used the below code.

Regards

What I have tried:

dtp2.Value = DateSerial(dtp2.Value.Year, dtp2.Value.Month,1).AddMonths(1).AddDays(-1)

Posted 6-Sep-19 17:30pm

qulaitks

Updated 6-Sep-19 23:39pm

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2019-09-06T19:53:00

Solution 1

Don't use outdated VB commands like DateSerial: use the DateTime constructor instead:

dtp2.Value = New DateTime(dtp2.Value.Year, dtp2.Value.Month, 1).AddMonths(1).AddDays(-1)

Posted 6-Sep-19 19:53pm

OriginalGriff

Comments

qulaitks 7-Sep-19 5:50am

Thanks OriginalGriff for the quick respond. I have tried the given code but still reciving the same error massage.

regards

OriginalGriff 7-Sep-19 6:04am

So use the debugger and find out exactly aht dtp2 holds ... the code works here, so it has to be data related, and we don't have access to that!

zamanipour 7-Sep-19 8:10am

maybe the problem raise from the initial value of dtp2.Value. check it to be valid or use a valid date for test, like : 'm = new DateTime()' and then: 'dtp2.Value = New DateTime(m.Year, m.Month, 1).AddMonths(1).AddDays(-1)'

qulaitks 7-Sep-19 21:46pm

Good Morning

I am using the DTP that has format (MMM-yyyy) to filter DGV , the code above works fine if months days are the same , as soon as the months days changes from say 31 to 30 , I receive the erroe massage. Sorry if i did not explain things right.

best regards