When i set both date separator and time separator as same in Regional settings, CDate() and IsDate() is failing in VBA. For example if i give CDate(“5:6:2004 5:30 PM”) is giving “Type Mismatch.” error..