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

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??

Mike MillerSoftware EngineerAsked:
Who is Participating?
craskinConnect With a Mentor Commented:
are you displaying this in a gridview? if so, set DataFormatString="{0:d}" HTMLEncode="False" on the boundfield.
might try...

Format(drDataRow("InspectDate"), "M/dd/yyyy")
Mike MillerSoftware EngineerAuthor Commented:
very nice...thanx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.