[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 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french

Ccleaner starts at boot.