Type Mismatch error with CDate - TechRepublic
Question
March 17, 2010 at 08:45 AM
sankulpune

Type Mismatch error with CDate

by sankulpune . Updated 16 years, 3 months ago

Hi,

I have following code in my if 6 program

Const ChkDate as String = “10 Match 2010”

If Now() > CDate(ChkDate) then

msgbox “Send Reminder”

End If

This program runs perfectly on my PC.

I created the exe and sent it to another location. The exe runs without any
problems on PCs at this location.

The same exe does not run on a PCs at third location. It gives error No.: 13,
Type mismatch.

I have tried to analyze this problem but unable to understand any reason why
this error should occur only at third location and how we can resolve this. All
locations have Win XP. I have also verified that system settings are similar.

Can anybody suggest the reason and the remedy? Am I overlooking any particular
system setting?

This discussion is locked

All Comments