<div>
Hi,<br />
<br />
Any of the following will do the job for you.<br />
<br />

<pre><code id="code-20-40727129-1">txtDateCompleted.Text = Convert.ToDateTime(objDR3(&quot;DATECOMPLETED&quot;)).ToString(&quot;dd/MM/yyyy&quot;, System.Globalization.CultureInfo.InvariantCulture)</code></pre>
<br />
OR<br />
<br />

<pre><code id="code-20-40727129-2">txtDateCompleted.Text = Convert.ToDateTime(objDR3(&quot;DATECOMPLETED&quot;)).ToString(&quot;dd/MM/yyyy&quot;)</code></pre>
</div>


Hi,

Any of the following will do the job for you.



txtDateCompleted.Text = Convert.ToDateTime(objDR3("DATECOMPLETED")).ToString("dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture)


OR



txtDateCompleted.Text = Convert.ToDateTime(objDR3("DATECOMPLETED")).ToString("dd/MM/yyyy")

<div>
Thanks, that works....... however in some cases the record maybe blank and this throws an error. &nbsp;How can I cater for null values?
</div>


Thanks, that works....... however in some cases the record maybe blank and this throws an error.  How can I cater for null values?

<div>
oh yes, why didn't I think of that.... perfect thanks.
</div>


oh yes, why didn't I think of that.... perfect thanks.

<div>
<div class="content wysiwyg-content">
How do I format a value from the DB as just dd/mm/yyyy<br />
<br />
txtDateCompleted.Text = objDR3(&quot;DATECOMPLETED&quot;)<br />
<br />
shows as - &nbsp; &nbsp;22/05/2014 00:00:00<br />
<br />
I'd like to get rid of the &nbsp; 00:00:00<br />
<br />
I have tried<br />
<br />
&nbsp;txtDateCompleted.Text = objDR3(&quot;DATECOMPLETED&quot;).To<wbr />String(&quot;dd<wbr />/MM/yyyy&quot;)<wbr /><br />
<br />
<br />
but this does not work.
</div>
</div>


How do I format a value from the DB as just dd/mm/yyyy

txtDateCompleted.Text = objDR3("DATECOMPLETED")

shows as -    22/05/2014 00:00:00

I'd like to get rid of the   00:00:00

I have tried

 txtDateCompleted.Text = objDR3("DATECOMPLETED").ToString("dd/MM/yyyy")


but this does not work.

Asp.net(vb) Format textbox as date no time.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,