Need to compare 2 date variables. 1 variable is a string, the other variable is a date variable

[adibakale]

I need to compare 2 dates that are stored in variables. The problem I am having is that the first date is stored in a Date type variable, the 2nd is stored in a string type variable. The reason the 2nd date is in a string type variable is because it is pulling the date from a different application and is stored as a string in that application.

Here is the line of code that I am comparing.
dim t_date as date
dim cl_date as string
If t_date < cl_date then

Basically, I need to convert cl_date variable to a date type variable so that I can compare the 2 dates.

The format of t_date is 0/00/0000 and the format of cl_date is 00/00/0000.

any help with this is greatly appreciated

 

[Crystalyzer]

how about doing this comparison

If WorksheetFunction.Text(t_date, "mm/dd/yyy") = cl_date Then

 

[xladept]

Maybe:

[B]If t_date < CDate(cl_date) Then[/B]

 

[Gingertrees]

Regardless of how the cldate cell is fed, you should be able to get Excel to recognize a string of 00/00/0000 as a date if you dim it so. For example, if tdate is in A2, and cldate is in B2, you could do this:

Sub compdts()
Dim tdate As Date
Dim cldate As Date
tdate = Range("A2")
cldate = Range("B2")
If tdate < cldate Then
MsgBox ("tdate is earlier")
End If


End Sub

 

[Jonmo1]

You can still Dim cl_date As Date
Even if the source value is a String.

As long as that string is in a valid date format, then it will work.