[VBA]Convert a string to date Solved

Question

Hello,

I have a problem with dates in VBA...

Let's say I have a string st = "12/03/2009" and I want to convert it to Date...

Does anyone know how to do this?

PS: I am new to VBA

Best regards,

green

Configuration: Windows 2000 Firefox 3.0.7

lermite222 · Accepted Answer

only useful when...
MyDate = "February 12, 1969" ' Defines the date.
MyShortDate = CDate(MyDate) ' Converts to Date type.
Otherwise, dates written in literal form like 12/12/2008 for example, are automatically considered as a date.
--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)

lermite222 · Answer

Hello,
There's nothing to do; it's automatically a date you can work with.

See you!
--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)

lami20j · Answer

Hello,  There is the CDate function -- 106485010510997108

greenthumb · Answer

Re,

thank you very much for the CDate function, it was just what I needed ;)

lermite, do you mean that a string in the form of "12/02/2009" can then be directly compared to a variable in date format?

greenthumb · Answer

Alright, I didn’t know that... it’s always good to know :)  Thank you, have a great day ;)

lami20j · Answer

Re,  Otherwise, dates written in literal form like 12/12/2008, for example, are automatically considered as a date. Yes, that's exactly it ;-) -- 106485010510997108

lami20j · Answer

Re,  Also for testingSub string2date() Dim st As String, st2 As String, st3 As Date Dim dt As Date, dt2 As Date, dt3 As Date st = "12/03/2009" dt = CDate(st) If st = dt Then MsgBox "ok" Else MsgBox "no" End If st2 = "12 February 1969" dt2 = CDate(st2) If st2 = dt2 Then MsgBox "ok 2" Else MsgBox "no 2" End If st3 = "18/03/2009" dt3 = CDate(st3) MsgBox DateDiff("d", st2, dt3) MsgBox DateDiff("d", dt2, dt3) End Sub -- 106485010510997108

lermite222 · Answer

Re,
And to be complete, Cdate (or formerly CVdate) may also be necessary when extracting a date from a database or a text/csv file
See you later
--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)

greenthumb · Answer

Indeed it works... great !!  Thank you very much :)

[VBA]Convert a string to date

9 answers

Anomalies in my laptop usage: virus?

No network inside the house.

How to reset a gps on a 2010 automatic c4 picasso clocking?

Z10 that won’t boot anymore

Question about transferring data ps4 to ps5

Smart tech tv without remote control

I no longer have the scrollbar in the right margin

Doctolib plans to use your health data for its ai research

Google maps does not recognize my current location [pc]

Understanding the use of the 'i' compartment in the washing machine