Discussion Locked

CDate() problem

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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..

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.