View Single Post
Old 09-20-2012, 11:31 PM   PM User | #12
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,556
Thanks: 62
Thanked 4,055 Times in 4,024 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
AHHH!!! I *MISSED* this comment in one of your prior posts:
Quote:
It works with Cncrt_Date. It does not work with Cncrt_Dateseq.
That clearly indicates that one of the values in the CNCRT_DATESEQ indeed has a problem! If Access couldn't use that column, then neither could VBScript.

So just change to using that column in the IF test:
Code:
<%
If DATEVALUE( CDATE( objRS4("Cncrt_Date") ) ) = DATE() Then
    Response.Write "<h1>" & objRS4("Cncrt_Date") & "</h1>"
Else
    Response.Write "<h3>" & objRS4("Cncrt_Date") & "</h3>"
End If
%>
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote