<div>
strsqlg = &quot;SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=&quot;&amp;Session(UserID)<wbr />&amp;&quot; AND [dateTime] &gt;= '&quot;&amp; DateAdd('h', -24, Date()) &amp;&quot;'&quot;
</div>


strsqlg = "SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID="&Session(UserID)&" AND [dateTime] >= '"& DateAdd('h', -24, Date()) &"'"

<div>
strsqlg = &quot;SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=&quot; &amp;&nbsp;Session(UserID) &amp;&nbsp;&quot; AND [dateTime] &gt;= GETDATE() - 1&quot;
</div>


strsqlg = "SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=" & Session(UserID) & " AND [dateTime] >= GETDATE() - 1"

<div>
Or strictly speaking:<br />
strsqlg = &quot;SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=&quot; &amp;&nbsp;Session(UserID) &amp;&nbsp;&quot; AND [dateTime] BETWEEN GETDATE() - 1 AND GETDATE()&quot;
</div>


Or strictly speaking:
strsqlg = "SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=" & Session(UserID) & " AND [dateTime] BETWEEN GETDATE() - 1 AND GETDATE()"

<div>
Thanks for all your answers. &nbsp;First one worked so I accepted that one. &nbsp;=)
</div>


Thanks for all your answers.  First one worked so I accepted that one.  =)

<div>
Not a problem. &nbsp;Glad you got your problem solved.
</div>


Not a problem.  Glad you got your problem solved.

<div>
<div class="content wysiwyg-content">
I am trying to write this query in ASP for a MSSQL database so that it finds the records with the field 'datetime' in the past 24 hours. &nbsp;Right now it just return the one with todays date:<br />
<br />
strsqlg = &quot;SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID=&quot;&amp;Session(UserID)<wbr />&amp;&quot; AND dateTime =&quot;&amp;date()
</div>
</div>


I am trying to write this query in ASP for a MSSQL database so that it finds the records with the field 'datetime' in the past 24 hours.  Right now it just return the one with todays date:

strsqlg = "SELECT COUNT(*) AS SaleCount FROM [tblSales] WHERE sellerID="&Session(UserID)&" AND dateTime ="&date()

Returning records created within the last 24 hours

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.