Solved

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

Posted on 2007-03-22
3
248 Views
Last Modified: 2008-02-26
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
0
Comment
Question by:mwmiller78
3 Comments
 
LVL 6

Expert Comment

by:kerryw60
ID: 18774109
might try...

Format(drDataRow("InspectDate"), "M/dd/yyyy")
0
 
LVL 12

Accepted Solution

by:
craskin earned 500 total points
ID: 18774605
are you displaying this in a gridview? if so, set DataFormatString="{0:d}" HTMLEncode="False" on the boundfield.
0
 

Author Comment

by:mwmiller78
ID: 18774703
very nice...thanx
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question