Okay... It's too bad those are text fields, but luckily Access (JET) has an answer for that.
We can use *EITHER* the CNCRT_DATE or the CNCRT_DATESEQ field. Doesn't matter. Either will work. (But not the cncrt_dateasp field.)
SELECT * FROM concert_data
WHERE CDATE(Cncrt_dateseq) BETWEEN DATE() AND DATE()+60
ORDER BY Cncrt_dateseq DESC
Try that! In Access, before you try using it in your ASP code.
Notice that you NO LONGER need to pass in Today
from the ASP code. Let Access do the date arithmetic for you!
If that works (and I'm 90% sure it will), then you can just convert it to ASP thus:
sql4 = "SELECT * FROM concert_data " _
& " WHERE CDATE(Cncrt_dateseq) BETWEEN DATE() AND DATE()+60 " _
& " ORDER BY Cncrt_dateseq DESC"