Convert string to date

[banavas]

Dear Friends,

I have a string dS = "2005-04-21" and I want to convert it to a date variable in order to proceed with date functions.

How can I perform this operation?

Thank you in advance.
G.

[BrianB]

The easiest way is to use declared variables, when Excel handles the conversion automatically :-

Please Login or Register  to view this content.

[Leith Ross]

Hello Banavas,

To convert the string to a Date type, use the CDate() function. This will convert any valid date string format into a Date Data Type. This function is also internationally aware.

Convert a String into a Date Type:

Dim MyDate As Date
MyDate = CDate("2005-04-21")

Sincerely,
Leith Ross