ASP Date Help - If Then Else

I would suggest you use database (MS Access is the easiest for small data size) to run the application. See www.haneng.com for tutorials.

You can then use datediff function to calculate the duration to the next gig:

TodayDate = Date()
' Query from database
...
...
DateJoin = RS("GigDate")

' Do the calculation
Diff = DateDiff("d", DateJoin, TodayDate) 

If Diff = 0 Then .... End If
If Diff > 0 Then .... End If

You may use Select Case to control the display.

Also you need to observe how you use symbols in your code

<% if day(now)/month(now) = 17/6 then %>

actually means: "if day(now) divided by month(now) = 17 divided by 6 then"
and that's not really what you want to do.

It should by:

<% if day(now) & "/" & month(now) = "17/6" then %>

use a database it will be easier then run a sql command that orders the dates ASC (asending) while database date not smaller than current date.

SELECT Table1.ID,Table1.gigdate, IIf([Table1]![gigdate]>Date(),[gigdate],IIf([Table1]![gigdate]=Date(),"Today","past")) AS gig
FROM Table1
ORDER BY Table1.gigdate ASC

it returns a past if it is over (incase you need to list your past dates you can just make a recordset that lists all the dates that gig is "past")

for you upcoming events you could edit it to be like:

SELECT Table1.ID,Table1.gigdate, IIf([Table1]![gigdate]>Date(),[gigdate],IIf([Table1]![gigdate]=Date(),"Today","past")) AS gig
FROM Table1
WHERE IIf([Table1]![gigdate]>Date(),[gigdate],IIf([Table1]![gigdate]=Date(),"Today","past"))  <> "past"
ORDER BY Table1.gigdate ASC

there is a more gracefull way i konw but this gives the possibility of more options

Thats for an access query. The sql in the asp page would be a bit different though