<div>
what database?<br />
<br />
mssql server:<br />
&nbsp; &nbsp; &nbsp; strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=getdate()<wbr /> &quot;<br />
<br />
oracle:<br />
&nbsp; &nbsp; &nbsp; strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=SYSDATE&quot;<br />
<br />
mysql:<br />
&nbsp; &nbsp; &nbsp; strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=CURRENT_D<wbr />ATE()&quot;<br />
<br />
access<br />
&nbsp; &nbsp; &nbsp; strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=now()&quot;<br />
<br />
also, do you have time portion in the date field?<br />

</div>


what database?

mssql server:
      strSQL="Select * FROM members WHERE mGoldFinishDate<=getdate() "

oracle:
      strSQL="Select * FROM members WHERE mGoldFinishDate<=SYSDATE"

mysql:
      strSQL="Select * FROM members WHERE mGoldFinishDate<=CURRENT_DATE()"

access
      strSQL="Select * FROM members WHERE mGoldFinishDate<=now()"

also, do you have time portion in the date field?


<div>
SQL server<br />
<br />
datetime field
</div>


<div>
And then I want to update all the fields like this<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF NOT objRS.EOF THEN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objRS(&quot;mType&quot;) = 0<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END IF
</div>


And then I want to update all the fields like this

      IF NOT objRS.EOF THEN
      
      objRS("mType") = 0
      
      END IF

<div>
<div class="content wysiwyg-content">
How can I make this work<br />
<br />
<br />
&lt;!--#include file=&quot;../../sqlcon/db.asp&quot;<wbr /> --&gt;<br />
&lt;% &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;datNow = date()+time()<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=&quot;+cstr(da<wbr />tNow)+&quot;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set objRS = Server.CreateObject(&quot;ADODB<wbr />.Recordset<wbr />&quot;)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objRS.Open strSQL, objCON, 3, 3<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF NOT objRS.EOF THEN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END IF<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objRS.Close<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objCON.close &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
%&gt;
</div>
</div>


How can I make this work



<%	 
	datNow = date()+time()

	
	strSQL="Select * FROM members WHERE mGoldFinishDate<="+cstr(datNow)+""
	Set objRS = Server.CreateObject("ADODB.Recordset")
	objRS.Open strSQL, objCON, 3, 3
	
	IF NOT objRS.EOF THEN
	
	END IF
	
	objRS.Close
	objCON.close	
%>

strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=&quot;+cstr(datNow)+&quot;&quot;

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

strSQL=&quot;Select * FROM members WHERE mGoldFinishDate&lt;=&quot;+cstr(datNow)+&quot;&quot;

strSQL="Select * FROM members WHERE mGoldFinishDate<="+cstr(datNow)+""