ActiveX VBScript DTS IsDate

Can someone explian why I get a return of not a valid date when using
activeX vbscript for DTS:
Select (Date())
Case (IsDate(Date())
msgbox "OK"
Case Else
msbox "I cant figure this out"
End Select
msbox "I cant figure this out" pops rather than msgbox "OK"Your Select Case statement is malformed. Try:
Select Case IsDate(Date())
Case True
MsgBox "OK"
Case Else
MsgBox "I cant figure this out"
End Select
Hope this helps.
Dan Guzman
SQL Server MVP
<lebeau777@.hotmail.com> wrote in message
news:1143836184.567616.6570@.z34g2000cwc.googlegroups.com...
> Can someone explian why I get a return of not a valid date when using
> activeX vbscript for DTS:
> Select (Date())
> Case (IsDate(Date())
> msgbox "OK"
> Case Else
> msbox "I cant figure this out"
> End Select
> msbox "I cant figure this out" pops rather than msgbox "OK"
>|||Please ignore my previous response (copy/paste error). The script should
be:
Select Case IsDate(Date())
Case True
msgbox "OK"
Case Else
msgbox "I cant figure this out"
End Select
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:u45IViZVGHA.3716@.TK2MSFTNGP15.phx.gbl...
> Your Select Case statement is malformed. Try:
> Select Case IsDate(Date())
> Case True
> MsgBox "OK"
> Case Else
> MsgBox "I cant figure this out"
> End Select
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <lebeau777@.hotmail.com> wrote in message
> news:1143836184.567616.6570@.z34g2000cwc.googlegroups.com...
>

Active X sql error

Sql Windows/32 ActiveX error
ActiveX object creation failed-please check that your
installation is valid.
How can i fix this error? The user can execute the
command on other machines except his own. Is there
something Im missing?
And you get this error when? What command is being executed
from what application/tool? The general message can happen
for many reasons. Without any more information, it's
difficult to help you troubleshoot this. Generally you see
it when you try to instantiate an object and it fails due to
a dll not being properly registered or present on the
machine.
-Sue
On Tue, 8 Jun 2004 10:35:42 -0700, "Matt"
<bonefish8@.hotmail.com> wrote:

>Sql Windows/32 ActiveX error
>ActiveX object creation failed-please check that your
>installation is valid.
>
>How can i fix this error? The user can execute the
>command on other machines except his own. Is there
>something Im missing?