VBA:Compare two date formats in vba

Question

How do we compare two date strings in vba, like "01.02.2013 < 02/02/2013"? Whatever the dates are this always showing true. And two date formats are correct in the example i menioned.

Below vba code throws error.

Sub aa()
Dim a As Variant, b As Variant, c As Variant
a = Format("1.2.2012", "DD\/MM\/YYYY")
b = Format("2.2.2012", "DD\/MM\/YYYY")
MsgBox (a)
End Sub

Those aren't dates, they are date strings. Convert them to the Date datatype first, then compare them. — RBarryYoung
– RBarryYoung, Commented Jun 3, 2013 at 14:56

Aeronth · Accepted Answer · 2013-06-03 14:58:12Z

1

Convert your dates (strings) to a format CDate() accepts. 02/02/2013 works, I think 02.02.2013 doesn't. Use Replace() if needed.

Then you can cast your String data into the Date datatype with CDate(myString). Dates can be compared with each other by the means of the usual operators, such as > < =.

answered Jun 3, 2013 at 14:58

Aeronth

8141 gold badge6 silver badges17 bronze badges

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

Comments

user1064180 · Accepted Answer · 2013-06-03 15:06:03Z

1

Clean up the strings to the correct format (see what CDATE accepts, and then use CDate(a) >= CDate(b) to compare.

answered Jun 3, 2013 at 15:06

user1064180

1 Comment

user1064180 Over a year ago

apologies, Aeronth - hadn't seen your answer, mine is the same.

Collectives™ on Stack Overflow

VBA:Compare two date formats in vba

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related