Case statement

[Dave]

I am getting a syntax error on

Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select

[Bob Barrows]

Dave wrote:

I am getting a syntax error on

Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select

You're comparing a date to a string. Date literals need to be delimited by
hash marks (#):
Case > #2/2/2004 12:30:00 AM#

You can also use CDate to do the conversion:

Case > CDate("2/2/2004 12:30:00 AM")

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Ray at]

The select case statement in vbscript isn't as versatile as that in VB. Try
this:
Dim sNow
sNow = Now

Select Case True
Case DateValue(sNow) > DateValue("2/2/2004 12:30:00 AM")
Response.Redirect "votingover.asp"
Case Else
Response.Write "fine"
m=0
End Select

Ray at home

"Dave" <da***@helixpoint.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I am getting a syntax error on

Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select

[Bob Barrows]

Oops. The error message mislead me. Now if he had told us that the error
message was "syntax error", ...

Of course, this works as well (I tested it this time :-) ):
Select Case True
Case Now > #1/2/2004 12:30:00 AM#

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Ray at <%=sLocation%> wrote:

The select case statement in vbscript isn't as versatile as that in
VB. Try this:
Dim sNow
sNow = Now

Select Case True
Case DateValue(sNow) > DateValue("2/2/2004 12:30:00 AM")
Response.Redirect "votingover.asp"
Case Else
Response.Write "fine"
m=0
End Select

Ray at home

"Dave" <da***@helixpoint.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I am getting a syntax error on

Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select

[Ray at]

OP: "I am getting a syntax error on..."

;]

Ray at home

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:uy****************@TK2MSFTNGP09.phx.gbl...

Oops. The error message mislead me. Now if he had told us that the error
message was "syntax error", ...

Of course, this works as well (I tested it this time :-) ):
Select Case True
Case Now > #1/2/2004 12:30:00 AM#

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Ray at <%=sLocation%> wrote:

The select case statement in vbscript isn't as versatile as that in
VB. Try this:
Dim sNow
sNow = Now

Select Case True
Case DateValue(sNow) > DateValue("2/2/2004 12:30:00 AM")
Response.Redirect "votingover.asp"
Case Else
Response.Write "fine"
m=0
End Select

Ray at home

"Dave" <da***@helixpoint.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I am getting a syntax error on

Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select

[Bob Barrows]

Ray at <%=sLocation%> wrote:

OP: "I am getting a syntax error on..."

:-(

Time for a break. I read "type mismatch".

Maybe my vision was clouded by the comparison of the string to the date ...
but now that I test it, I see that an implicit conversion is done. This:

Select Case True
Case Now > "1/2/2004 12:30:00 AM"

works just as well as this:
Select Case True
Case Now > #1/2/2004 12:30:00 AM#

Sheesh.

Bob

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"