<div>
might try...<br />
<br />
Format(drDataRow(&quot;InspectD<wbr />ate&quot;), &quot;M/dd/yyyy&quot;)
</div>


might try...

Format(drDataRow("InspectDate"), "M/dd/yyyy")

<div>
<div class="content wysiwyg-content">
I'm pulling data from an Access DB, and one of the fields is date. Here's my query:<br />
<br />
select TargetCompany, ID, NextActionDate, NextAction from tblMain<br />
<br />
the date is comin up as general format including the 12:00:00AM even though I set the format of this field to ShortDate in Access. I tried using FORMAT(Date, 101) AS Date but it didn't seem to like it. How do I get the date to display without the 12:00:00AM??<br />
<br />
<br />
TIA
</div>
</div>


I'm pulling data from an Access DB, and one of the fields is date. Here's my query:

select TargetCompany, ID, NextActionDate, NextAction from tblMain

the date is comin up as general format including the 12:00:00AM even though I set the format of this field to ShortDate in Access. I tried using FORMAT(Date, 101) AS Date but it didn't seem to like it. How do I get the date to display without the 12:00:00AM??


TIA

Date Format (no 12:00:00AM) in ASP.NET(VB) from Access

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

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,

Visual Basic.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.