<div>
if this is ms sql use getdate()<br />
<br />
eg.<br />
DATEDIFF('d', date2, getdate()) 
</div>


if this is ms sql use getdate()

eg.
DATEDIFF('d', date2, getdate())

<div>
Date() worked great, thanks!
</div>


<div>
<div class="content wysiwyg-content">
What's the best way to get the current date in this query instead of the hard coded 10/15/2007?<br />
<br />
I've tried a couple scenarios with no luck. &nbsp;&lt;%response.write(date())%&gt;<wbr /> and (date())<br />
<br />
conn.open &quot;SELECT id, date1, EmpName, Software, Hardware, Comments, Status, date2, Comments2, Tech, Priority, DATEDIFF('d', date2, '10/15/2007') AS testouput FROM helpdesk WHERE (Status = 'closed') AND (DATEDIFF('d', date2, '10/15/2007') &lt;&nbsp;&quot; &amp;&nbsp;daysback &amp;&nbsp;&quot; ) ORDER BY id DESC;&quot;, &quot;DSN=helpdesk&quot;<br />
<br />
ideas?
</div>
</div>


What's the best way to get the current date in this query instead of the hard coded 10/15/2007?

I've tried a couple scenarios with no luck.  <%response.write(date())%> and (date())

conn.open "SELECT id, date1, EmpName, Software, Hardware, Comments, Status, date2, Comments2, Tech, Priority, DATEDIFF('d', date2, '10/15/2007') AS testouput FROM helpdesk WHERE (Status = 'closed') AND (DATEDIFF('d', date2, '10/15/2007') < " & daysback & " ) ORDER BY id DESC;", "DSN=helpdesk"

ideas?

asp sql syntax - current date- datediff

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.