VBA Convert String to Date using periods as date seperators

Question

I have tried the following but not working,

Dim my_date_string As String
Dim my_date_date As Date

my_date_string = "22.10.2020"
my_date_date = CDate(my_date_string)

Debug.Print my_date_string
Debug.Print my_date_date

Also tried with,

my_date_date = Format(my_date_string, "DD.MM.YYYY")

You try converting string to date... Your code works only with regionalization involving that type of data (in the string) as default. Doing what @braX recommended works in all cases, anyhow... — FaneDuru
– FaneDuru, Commented Nov 19, 2021 at 10:35

braX · Accepted Answer · 2021-11-19 10:58:21Z

1

CDate does not understand periods as separators.

If you need them to be periods in your String variable for some reason, just replace them like this:

my_date_date = CDate(Replace(my_date_string, ".", "/"))

If your variable does not have periods in it, the Replace function will simply do nothing.

edited Nov 19, 2021 at 10:58

answered Nov 19, 2021 at 10:30

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Convert String to Date using periods as date seperators

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related