Convert to date

[simon]

I get from the dateTimePicker the value: string="12/18/2003 11:52:28 AM"

Now I need to convert this to dateTime. Any function I use: Convert.ToDateTime(string) or Cdate(string), I get an error message:
String was not recognized as a valid DateTime.

What should I do?
Use replace function and mid function on string and at the end convert it to date?

Thank you for your answer,
Simon

 

[Armin Zingler]

I get from the dateTimePicker the value: string="12/18/2003 11:52:28
AM"

Now I need to convert this to dateTime. Any function I use:
Convert.ToDateTime(string) or Cdate(string), I get an error message:
String was not recognized as a valid DateTime.

What should I do?
Use replace function and mid function on string and at the end
convert it to date?

You're from Slovenia? Do you have the English date/time format? Here in
Germany it is dd.mm.yyyy hh:mm:ss, so ConvertToDateTime("18.12.2003
11:52.28") works.

 

[Herfried K. Wagner [MVP]]

I get from the dateTimePicker the value: string="12/18/2003 11:52:28 AM"

Now I need to convert this to dateTime. Any function I use: Convert.ToDateTime(string) or Cdate(string), I get an error message:

String was not recognized as a valid DateTime.

Did you try it with 'DateTime.Parse' or 'DateTime.ParseExact'?

 

[simon]

I tried with 'DateTime.Parse' and 'DateTime.ParseExact' and still doesn't
work, the same error message.

Thank you,
Simon

 

[simon]

What you mean? I didn't found founction ConvertToDateTime?
Thank you,
Simon

 

[Armin Zingler]

What you mean? I didn't found founction ConvertToDateTime?

A little bit more creativity, please! ;-) Fun only...

Convert.ToDateTime

Dots cost extra. ;-)

 

[Cor]

Hi Simon,

I am also from Europe

Dim b As New DateTime
b = Convert.ToDateTime("18/12/2003 11:52:28 AM")
MessageBox.Show(b.ToString)

Works for my

Cor

 

[Cor]

Hi Armin,

Germany it is dd.mm.yyyy hh:mm:ss, so ConvertToDateTime("18.12.2003
11:52.28") works.

Really?

))

Cor

 

[Armin Zingler]

Really?

))

Yes, really:
Private Function ConvertToDateTime(ByVal s As String) As Date
Return Convert.ToDateTime(s)
End Function


;-))

 

[Cor]

Hi Armin,

Look again, you know that I would not send it like this if there was not
something with it that was something absolute not important.

 

[Armin Zingler]

Hi Armin,

Look again, you know that I would not send it like this if there was
not something with it that was something absolute not important.

I thought you referred to the wrong function name.

[/QUOTE]

 

[simon]

I read a value from timePicker and it is:

start="12/18/2003 11:52:28 AM" String

If I watch function now:

dim dt as DateTime
dt=Now() I get:
dt=#12/19/2003 9:09:19 AM# Date
so I guess this is my system dateTime format.

Then if I use:
dt = Convert.ToDateTime(start)

I still get an error message:
String was not recognized as a valid DateTime.

I don't know what else should I do?

Thank you,
Simon

 

[Cor]

Hi Simon,

When I try this I get 3 times the date from now
MessageBox.Show(Me.DateTimePicker1.Value.ToString)
Dim b As New DateTime
b = Convert.ToDateTime(Me.DateTimePicker1.Value.ToString)
MessageBox.Show(b.ToString)
Dim c As DateTime
MessageBox.Show(c.Now().ToString)

Can you try it also?

Cor

 

[Phill. W]

OK, I'm new around here but...

I get from the dateTimePicker the value:
string="12/18/2003 11:52:28 AM" .. . .
Now I need to convert this to dateTime.

No, you don't.
The DateTimePicker's Value property is /already/ of Type
DateTime (not String), so you should be able to use the value
directly, without any conversion at all.

Air-Code (finger's crossed)

Dim SomeTimeSoon as New DateTime
SomeTimeSoon = DateTimePicker1.Value
MessageBox.Show( SomeTimeSoon.ToString() )

HTH,
Phill W.

 

[Herfried K. Wagner [MVP]]

I read a value from timePicker and it is:

start="12/18/2003 11:52:28 AM" String

Why not use the 'Value' directly?

 

[Cor]

Hi Herfried,

What does Armin always says about echo?

I did give him the change to find that himself with my example.

Cor

 

[Herfried K. Wagner [MVP]]

What does Armin always says about echo?

I did give him the change to find that himself with my example.

LOL... I made it easier for the OP...

;-)

 

[Armin Zingler]

Hi Herfried,

What does Armin always says about echo?

I did give him the change to find that himself with my example.

??
Sorry, I don't understand you again.

 

[Cor]

Hi Armin,

??
Sorry, I don't understand you again.

Intruiging, but Herfried does, it is not important that you do understand
this.

Cor

 

[Herfried K. Wagner [MVP]]

Intruiging, but Herfried does, it is not important that you do understand
this.

LOL