Got a quick question..

Is there a between clause that can be used in an If Then statement?

Something like:
If strDate BETWEEN "03/01/2004" AND "04/01/2004" Then
  Response.Write "Something"
Else
  Response.Write "Something Else"
End If

I need to check that a date is "between" 2 dates like above and the If Then statement is pretty much what I need. Any help is greatly appreciated!

Note: Can someone ask a really, really easy question so that maybe I can answer?!? Seems like I'm always asking you guys for help, and not giving anything back. I figure something like "What's ASP stand for?" would do just fine. I think I could handle that one. Yeah.... I could answer that one...

:o)

Chris

To tell you the truth I can't rememeber in VBScript but you can use:
However if your strDate is a string you are doing a string comparison, not on the date. If strDate is a Date then you need to make sure your computer interprets "03/01/2004" as the date you intend it to be. Better if you convert it to a date yourself by hand and then test.

--

Joe

Ahhh.. I forgot about it may not be an actual date. I'm querying data from an AS/400 and there are times when the data contained in the libraries is actually text when you think it's numeric. Let me try that date conversion and see what happens. Thanks!