Problem converting a string into date in vb.net

[veer]

Hi
I have a probleum in vconverting a string value into date in vb.net
e.g
str="31.12.2005"
i want to convert it into date format like "mm/dd/yyyy"
i use CDATE function for it but every time error comes " String can't be converted into date"

but when i use any other value like 12.31.2005 it works fine

how can i change the first str value into 2nd value because from where i am accessing the always have the value "31.12.2006"


please give me some idea

[CyberSoftHari]

Hi
I have a probleum in vconverting a string value into date in vb.net
e.g
str="31.12.2005"

You can conver using ToString("MM/dd/yyyy")

str="31.12.2005"
DateTime thisDate = Convert.ToDateTime(str.ToString("MM/dd/yyyy"))
 

[veer]

Hi
thanks for reply
i used your code like this

 Dim str As String 
Dim thisdate As DateTime
Str = "31.12.2005"
thisdate=Convert.ToDateTime(str.ToString("MM/dd/yyyy"))
 

it shows the following error

Unable to cast object of type 'System.String' to type 'System.IFormatProvider'.

[CyberSoftHari]

Okay Use like

thisdate = DateTime.Parse(str.ToString("MM/dd/yyyy"))

[Curtis Rutland]

This is what you need to do. You need to parse your string, and then create a DateTime object from the pieces.

string s = "31.12.2008";
string[] delims = { "." };
string[] tokens = s.Split(delims,StringSplitOptions.None);
DateTime d = DateTime.Parse(String.Format("{0}/{1}/{2}", tokens[1], tokens[0], tokens[2]));
 

Hi
I have a probleum in vconverting a string value into date in vb.net
e.g
str="31.12.2005"
i want to convert it into date format like "mm/dd/yyyy"
i use CDATE function for it but every time error comes " String can't be converted into date"

but when i use any other value like 12.31.2005 it works fine

how can i change the first str value into 2nd value because from where i am accessing the always have the value "31.12.2006"


please give me some idea

[Plater]

There is an even easier way.

string s="31.12.2005";
DateTime dt=DateTime.ParseExact(s, "dd.MM.yyyy", System.Globalization.CultureInfo.CurrentCulture);
MessageBox.Show(dt.ToString("MM/dd/yyyy")); 
 

[veer]

Hi
i made a program in which i want to convert a string into date and make an exe
but when i run this exe on my computer it works fine & display the date
but when i use this exe on any other computer
i display the error
"the string is cannot be converted into date"
i use this line in my coding

 Dim tempstr As String 
Dim eddate As Date
tempstr = "11/26/2006"
eddate = CDate(tempstr)
MsgBox(eddate)
 

please tell me what is wrong

With reGArds
varinder

[shweta123]

Hi,

I think you are getting "String to Date conversion error" because of different datetime formats on each machine. When you use cDate function ,if month you specify in date is not valid you may get the error. So , you have to write the code in your application to get the string with valid date in required date format.

[veer]

Thanks shweta123
but will you give some code example

reGArds
varinder

Hi,

I think you are getting "String to Date conversion error" because of different datetime formats on each machine. When you use cDate function ,if month you specify in date is not valid you may get the error. So , you have to write the code in your application to get the string with valid date in required date format.

[Curtis Rutland]

You can see some code examples of this on your own thread from yesterday. Some of them are in C# but you should be able to figure out the VB from that.

Plater's example is the easiest way, and if his doesn't work, mine will if you substitute "/" for "."

[Plater]

I have merged these threads.
Please do not double post your questions, its against the posting guidelines.

MODERATOR


Many solutions have already been outlined for you, have you even tried them?