how to validate date in vb.net

Question

1.00/5 (1 vote)

See more:

Hello,

I am using date for policy in my project where start date will be first day of any month and end date will be last day of start date month's last day..Policy will be valid for one year after one year policy should be get renewed.so for this how to do validation on date..
I'll be very much thankful if u resolve this ...

~~Its very urgent so please give me answer ASAP..~~
I'm waiting for ur answer..

Thank u folks :-)

[Edit] Removed urgency because we answer on our own personal time [/Edit]

Posted 25-Feb-14 0:25am

Varsha Bhosle

Updated 25-Feb-14 0:27am

phil.o

v3

Add a Solution

2 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)

OriginalGriff · Answer 1 · 2014-02-25T00:34:00

Solution 2

Exactly how you will validate this is really down to you: we have no idea how you are storing the info, or what needs verifying where, or even when.

But... working it out is pretty easy:
Assume you are working with today:

VB

Dim today As DateTime = DateTime.Now.[Date]
Dim start As New DateTime(today.Year, today.Month, 1)
Dim [end] As DateTime = start.AddMonths(1).AddDays(-1)
Dim renew As DateTime = [end].AddYears(1)

Posted 25-Feb-14 0:34am

OriginalGriff

Comments

Varsha Bhosle 25-Feb-14 6:47am

Thanks a lot :-)

Actually I m importing data from ms access database to ms sql server 2005 ,its having field as InsuranceStartDate and InsuranceEndDate so i want to validate this ..

OriginalGriff 25-Feb-14 7:18am

So read the value from Access into a DateTime.
Use the Date property to remove any time info - it resets to midnight.
Then create what you think the values should be (start, end, renew) using the above and compare them against the Access DB values.

phil.o · Answer 2 · 2014-02-25T00:29:00

Solution 1

What did you try? Where are you stuck? Where is your code?

Posted 25-Feb-14 0:29am

phil.o

Comments

Varsha Bhosle 25-Feb-14 6:31am

I did not try anything i want logic behind this to achieve it..

udaybhaskars 27-Feb-14 1:30am

hi phil.o,

This is not a solution add it in comments, don't add solution just for points. Please try to add proper solutions otherwise its waste of time for the users who are searching for the same question.