Format Masked textbox date

Question

1.00/5 (1 vote)

See more:

Hello Experts

I am Using MaskedText Box For Entering Date And I Use MAsk is Shortdate
My Question is How To Validate This MaskedtextBoxt if it is Valid Date or Not
I try Using IsDate But That is Not Working Bcoz The Text in masked TextBox is eg "12 /02 /2008" like this
Also This Text How to Format Like yyyy/MM/dd for inserting in SQl
I also Use Format But This Already string So it cannot Be Format

Plz give me Suitable Reply , Urgent

Chaitanya

Posted 23-Jan-14 21:19pm

Member 10546030

Add a Solution

Comments

Karthik_Mahalingam 24-Jan-14 3:28am

post code

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)

Maciej Los · Answer 1 · 2014-01-23T21:40:00

Solution 2

You don't need to format anything! Date should be a date, not string!

If you want to insert data into SQL database, you should know the format which is used by MS SQL server. Have a look at SET DATEFORMAT[^] command.

Finally, you should use stored procedure[^]:

SQL

USE DataBaseName;
CREATE PROCEDURE InsertMyData 
    @myDate DATETIME
AS
BEGIN

SET DATEFROMAT dmy;
INSERT INTO TableName (DateField)
VALUES(@myDate)

END

Posted 23-Jan-14 21:40pm

Maciej Los

Comments

phil.o 24-Jan-14 3:42am

I gave up counting how many times it has been said that dates/times should be handled as dates/times rathers than strings, and that formatting of these values should only be involved on the presentation side.
My 5 :)

Maciej Los 24-Jan-14 3:46am

Don't give up! Stand up and fight!

Your brother in arm
Maciej

Thank you, Phil ;)