[coachdan32]

I am trying to come up with an idea on writing an effective script (ASP) to compare the date to another date hard-coded in and return the correct info. It is for a baseball teams website to list where each team is each day. My idea is to have it scroll across in a marquis if it's possible.

Here's my thought process:

varToday = Date() 'store todays date in variable

Select Case varToday

Case 03/30/05
Freshmen vrs. Ballard (A) 6:30
JV - idle
Varsity vrs. Ballard (H) 4:30

Case 03/31/05
Freshman vrs. Eastern (H) 4:30
JV vrs. Eastern (H) 7:00
Varsity vrs. Eastern (A) 4:30

End Select

I know there is more to it than that, but I am not sure how to proceed. Can it be done in a scrolling marquis? I am not using a db at this time - it will be hard-coded.

[coachdan32]

Any thoughts?

[coachdan32]

I decided to abandon the scrolling marquis idea - I am going to add a table to do it in.

I have 3 columns that I am going to call the variables in (varVarsity, varJV, varFresh). I am using the following scenario to determine contents:

varDate = Date()

Select Case varDate
Case 3/28/05
varVarsity = "idle"
varJV = "Ballard (A) 7:00"
varFresh = "Ballard (A) 4:30"
End Select

This is just one instance of the select statement, there are many more dates. I have 2 main problems I could use advice on:

1. I am not sure what format the date will be coming in. Will it be an actual date? Or will it be a number? Does the select statement date need to be in quotes?

2. Somehow I need to put the Select inside a nested IF and I don't know how to handle this. I only hard-coded the dates between the start of the season and the end of the season. Before it enters the Select Statement I need to check the value and if it is before 3/28/05, I need to set all three variables to "idle". Also, if the value is greater than 5/20/05, I need to set all three variables to "idle". Any suggestions would be great?