<div>
Thank you Dirk Strauss for the explanation, and I would like to say thank you also to Ryan's solution for his solution which work perfectly. &nbsp;More power to you both. God bless!
</div>


Thank you Dirk Strauss for the explanation, and I would like to say thank you also to Ryan's solution for his solution which work perfectly.  More power to you both. God bless!

<div>
Great solution, very smart!
</div>


<div>
<div class="content wysiwyg-content">
Hi experts, I have a problem obtaining data in sqlserver in which in my sql command I need to advance 1 day of my time end before able to obtain the data. &nbsp;My data field in sql is look like this, &quot;2017-08-17 10:00:00.000&quot; &nbsp;this means that it has a time and this is August 17, 2017. In my sql command I cannot obtain this record if i set the time end to &quot;08/17/2017&quot; but &nbsp;&quot;08/18/2017&quot; meaning i need to advance 1 day. Is there anyone who can explain me why. What shall i do to make my sql command set &quot;08/17/2017&quot;?<br />
<br />

<pre><code id="code-10-29051136-1">Set rs = cn.Execute(&quot;Select Proname, TheDate,  from sTable where TheDate Between '&quot; &amp; &quot;08/17/2017&quot; &amp; &quot;' And '&quot; &amp; &quot;08/17/2017&quot;) &amp; &quot;) </code></pre>
</div>
</div>


Hi experts, I have a problem obtaining data in sqlserver in which in my sql command I need to advance 1 day of my time end before able to obtain the data.  My data field in sql is look like this, "2017-08-17 10:00:00.000"  this means that it has a time and this is August 17, 2017. In my sql command I cannot obtain this record if i set the time end to "08/17/2017" but  "08/18/2017" meaning i need to advance 1 day. Is there anyone who can explain me why. What shall i do to make my sql command set "08/17/2017"?

(CODE)

Accessing sql data with datetime

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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

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.