Date Giving Me #Error No Matter How I Try to Format It :-(

Hello,

Your date value is null (in VB = Nothing) and if you apply it to a function like IsDate() it will cause an error. You have to check it on Nothing before you us it

Is dt is Nothing
    return "Empty"
End If

If IsDate(dt)
    return "Yes"
End If

---

Olaf Helper

[ Blog] [ Xing] [ MVP]