VBA - convert to date

string vba excel date-conversion
InformatikBabo picture InformatikBabo · Nov 6, 2013 · Viewed 95.5k times · Source

I have one more time a problem:

I want to convert from Strings to dates in VBA

The Strings look like: YYYY-DD-MM

The date should be like: DD.MM.YYYY

I know, normally you do this with the method cdate(), but it doesn't work here. I think it's because the structure of the string is bad to convert.

thanks for your help

InformatikBabo

Answer

user2140173 picture user2140173 · Nov 6, 2013 
Sub Main()

    Dim strDate As String
    strDate = "2013-06-11"

    Debug.Print "Original Date: ", strDate
    Debug.Print "CDate() Conversion: ", CDate(strDate)
    Debug.Print "Format() as String: ", Format(strDate, "DD.MM.YYYY")

End Sub

and the Immediate Window shows

enter image description here

Related questions

String manipulation with Excel - how to remove part of a string if another part is there?

I've done some Googling, and can't find anything, though maybe I'm just looking in the wrong places. I'm also not very adept at VBA, but I'm sure I can figure it out with the right pointers :) I have a string …

Read More
Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07T02:36:17Z. The T and Z are very important for me. So I would like to insert them as well. …

Read More
display a 2 row message pop -up vba 6

is there a way to display a 2 or 3 or 4 or n line message on a pop-up window in vba 6 ? For the moment my pop-up window ( calling the MsgBox function) displays the message like this : You did something wrong. Please enter …

Read More