General discussion
August 6, 2004 at 03:55 AM
ganeshvishnu

CDate() problem

by ganeshvishnu . Updated 22 years, 1 month ago

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..

This discussion is locked

All Comments