Use stored procedure.
Query the date/time and use timespan, then use if else condition by comparing the date and time. I did this when working on tracking system.

I will code ASP - VB or C3 online quiz system for a small fee.

Dexter Zafra
http://www.myasp-net.com

I thought ASP Web Dev teacher should know ASP and SQL bec they got paid good money. Anyway, I changed the coding structure not to use response.write, instead use block so that its easy to read.
...