<div>
<div class="content wysiwyg-content">
Hi experts, I wish to add 1 day on the edate I have coded below. Something like this (edate + 1). can i do this? Thanks!<br />
<br />

<blockquote>
<br />
Set rs = cn.Execute(&quot;Select Proname, REMARK, TheDate, INPro, OUTPro, BALANCE from Stock where PROCODE='&quot; &amp;&nbsp;code &amp;&nbsp;&quot;' And TheDate Between '&quot; &amp;&nbsp;sdate &amp;&nbsp;&quot;' And '&quot; &amp;&nbsp;edate &amp;&nbsp;&quot;' Order by icount&quot;) <br />

</blockquote>
</div>
</div>


Hi experts, I wish to add 1 day on the edate I have coded below. Something like this (edate + 1). can i do this? Thanks!


Set rs = cn.Execute("Select Proname, REMARK, TheDate, INPro, OUTPro, BALANCE from Stock where PROCODE='" & code & "' And TheDate Between '" & sdate & "' And '" & edate & "' Order by icount") 


vb-script date

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.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.