Help understanding why a statement isn't true. oie.document.all.tags("input").value = date?

[redbull]

So I am navigating a website, I've come across a situation where there could be multiple textboxes on the page. So I have a loop that is going to determine all the values of the "input" tags on the page. I want to only change the input boxes that have todays date in them.

futuredate = Format(Date + 7, "m/d/yyyy")
Cnt = 0
With oie.document.all
    For Each oCell In .tags("input")
            If oCell.value = "3/7/2016" Then
                oCell.value = futuredate
            End If
        Cnt = Cnt + 1
        Debug.Print oCell.value & "-   Cnt is " & Cnt
    Next oCell
End With
Set oCell = Nothing

And this works fine, makes the changes without any issues. Now, when I try to replace the hardcoded date with Date, the code never picks it up in the if statement, even though ocell.value and date are both identical in the immediate window.

futuredate = Format(Date + 7, "m/d/yyyy")
Cnt = 0
With oie.document.all
    For Each oCell In .tags("input")
            If oCell.value = Date Then   ' This is a true statement, even the formatting is the same. Why doesn't it work? 
                oCell.value = futuredate
            End If
        Cnt = Cnt + 1
        Debug.Print oCell.value & "-   Cnt is " & Cnt
    Next oCell
End With
Set oCell = Nothing

Any advice? Kind of stumped on this one.

[pbaldy]

Date returns a number internally, so try:

If oCell.value = Format(Date, "m/d/yyyy") Then

[Micron]

The ocell.value might be text even though it looks the same as Date(), which is not text and will be represented according to your regional settings. The TypeName function may confirm this if you use it in a debug.print statement. The solution may be to coerce the value to a date (CDate), either directly or after assigning it to a variable. However, you must handle nulls or the cdate function will raise an error. Or you can concatenate date delimiters (#) into the string date, if in fact it is a string, before you compare it to Date().

[redbull]

Date returns a number internally, so try:

If oCell.value = Format(Date, "m/d/yyyy") Then

I can not believe that this was the problem. This worked great, thank you!

Is it just me or is it silly that the return for Date and Format(date,) is different? I mean, they both debug.print the same... but yea.

edit* a word

[pbaldy]

No, the Format() function always returns a string. Happy to help!