% @LANGUAGE = VBScript %> <% Option Explicit Response.Expires = 0 Dim strQuery, strPropno, strColour Dim dtVal %>
<% on error resume next strQuery="SELECT * from apps " strQuery=strQuery & "WHERE DATEVAL > '01/01/01' " strQuery=strQuery & "ORDER BY DateVal desc" set objRS=objConn.Execute(strQuery) %>These are the applications found for <% If isDate(objRS.fields("dateval")) then dtVal = FormatDateTime(objRS.fields("dateval"), 1) End If response.write dtVal %> |