<div>
That worked!, Thanks.<br />
<br />
Why did that work is another question I suppose. &nbsp;Perhaps the DateDiff function forces the two values to be viewed as the same type.
</div>


<div>
Grading Comments:<br />
That worked!, Thanks.<br />
<br />
Why did that work is another question I suppose. Perhaps the DateDiff function forces the two values to be viewed as the same type.<br />
<br />
<br />
I actually must think that either of the values also contains milliseconds, which were not displayed ...
</div>


<div>
<div class="content wysiwyg-content">
I have a field 'DateAdded' that is type DateTime in SQLServer 2005. &nbsp;I have a textbox on a form that has 'DateTime inserted into it on load.<br />
<br />
On exit I check to see if the DateAdded field has been changed by comparing the two<br />
<br />
If RS.Fields(&quot;DateAdded&quot;) &lt;&gt;&nbsp;CDate(txtDateAdded.Text) Then<br />
<br />
Watching the variables, both of them are:<br />
7/22/2008 4:05:00 PM<br />
<br />
I can't tell them apart. &nbsp;Why does the above If statemnt evalute as true?<br />

</div>
</div>


I have a field 'DateAdded' that is type DateTime in SQLServer 2005.  I have a textbox on a form that has 'DateTime inserted into it on load.

On exit I check to see if the DateAdded field has been changed by comparing the two

If RS.Fields("DateAdded") <> CDate(txtDateAdded.Text) Then

Watching the variables, both of them are:
7/22/2008 4:05:00 PM

I can't tell them apart.  Why does the above If statemnt evalute as true?


That worked!, Thanks.

Why did that work is another question I suppose.  Perhaps the DateDiff function forces the two values to be viewed as the same type.

Grading Comments:
That worked!, Thanks.

Why did that work is another question I suppose. Perhaps the DateDiff function forces the two values to be viewed as the same type.


I actually must think that either of the values also contains milliseconds, which were not displayed ...

vbDate not equal to CDate

I have a field &#39;DateAdded&#39; that is type DateTime in SQLServer 2005.  I have a textbox on a form that has &#39;DateTime inserted into it on load.

On exit I check to see if the DateAdded field has been changed by comparing the two

If RS.Fields(&quot;DateAdded&quot;) &lt;&gt; CDate(txtDateAdded.Text) Then

Watching the variables, both of them are:
7/22/2008 4:05:00 PM

I can&#39;t tell them apart.  Why does the above If statemnt evalute as true?


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.