date type conversion

Question

0.00/5 (No votes)

See more:

I am trying to convert string to date but the error would occur how to solve this problem?

error : Conversion from string "" to type 'Date' is not valid.
The string is in dd/mm/yyyy format and and I have used cdate and convert.todatetime functions but in both case conversion was not success-full.

Posted 24-Oct-10 20:15pm

Rounak Hasan

Updated 24-Oct-10 20:30pm

Sandeep Mewara

v2

Add a Solution

5 solutions

Solution 1

try using DateTime.Parse(string)
hope this helps you..

Posted 24-Oct-10 20:26pm

surender.m

Comments

Rounak Hasan 25-Oct-10 2:37am

DateTime.Parse(string) this will return 0 if it fails to convert which will be not accepted anyway...

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)

Sandeep Mewara · Accepted Answer · 2010-10-24T20:31:00

Solution 3

Error clearly state that the string is not Null or Empty. Put a check of String.IsNullOrEmpty(mystring), and then do the conversion. It would work.

UDPATE:
based on the changed error, try:

DateTime.ParseExact("18-12-2007", "dd-MM-yyyy", CultureInfo.InvariantCulture)<br />

This is needed to handle the date format you are using which is not a standard one.

Posted 24-Oct-10 20:31pm

Sandeep Mewara

Updated 24-Oct-10 20:59pm

v2

Comments

Sandeep Mewara 25-Oct-10 2:40am

Check at UI doesnt make sure always. It might be becuase of some scenario it got missed. Do a simple DEBUG and you can see if the value was right or not.
Error clearly states: Conversion from string "" .........
So it's an empty string that is bring tried to be converted.

Rounak Hasan 25-Oct-10 2:54am

o sorry this error was coming previously when then was no null checking....now it is showing exception message "the string is not a valid date" like this...

Sandeep Mewara 25-Oct-10 2:58am

Well, answer changes based on the error! Hope you understand now!

try:
DateTime.ParseExact("18-12-2007", "dd-MM-yyyy", CultureInfo.InvariantCulture);
This needs to be done as your date format is not a standard one.

demouser743 · Accepted Answer · 2010-10-24T20:29:00

Solution 2

string datestring = "20000101";
string date1 = DateTime.ParseExact(datestring, yyyyMMdd, null);
// ... or ...
DateTime dateResult;
if (!DateTime.TryParseExact(datestring, yyyyMMdd,
null, DateTimeStyles.AssumeLocal,
out dateResult))
dateResult = DateTime.MinValue;

Check this article too

http://www.codeproject.com/KB/cs/String2DateTime.asp[^]

Posted 24-Oct-10 20:29pm

demouser743

Updated 24-Oct-10 20:31pm

v3

Comments

Rounak Hasan 25-Oct-10 2:35am

my date string is going '25/10/2010' like this...

demouser743 25-Oct-10 2:42am

Output should be Ok what exact o/p you need i will give u the answer

demouser743 25-Oct-10 2:43am

what exact o/p you need i will give u the answer,

Rounak Hasan 25-Oct-10 2:52am

basically the are two string in dd/mm/yyyy format and i want to compare them..................I have used
If CDate(TextBox1To.Text.Trim) > CDate(TextBox2Fm.Text.Trim) Then

but it is showing exception..........The error was "the string is not a valid date" like this............

demouser743 25-Oct-10 2:57am

You can convert text from text box into DateTime object and use DateTime class methods or just subtract two DateTime objects which will give you TimeSpan objects. Then you can compare dates as per your requirements.

Rajesh Anuhya · Accepted Answer · 2010-10-24T20:39:00

check out the below codes

string tt = "21/10/2010";
          DateTime dt = new DateTime();
          dt = DateTime.Parse(tt);

OR

DateTime Dt1 = new DateTime(Convert.ToInt16 (tt.Substring(6, 4)),
                              Convert.ToInt16(tt.Substring(3, 2)),
                              Convert.ToInt16(tt.Substring(0, 2)));

R. Ansari · Accepted Answer · 2010-10-24T21:15:00

Solution 5

VB

If (strDate<> String.Empty) Then
               lblDate.Text = Convert.ToDateTime(strDate).ToString("dd/mm/yyyy")
           End If

Posted 24-Oct-10 21:15pm

R. Ansari

date type conversion

5 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us