Access date/field displays 12:00am in asp.net web form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am displaying fields from an access table using vb.net in a datagrid. One of the fields is a date/time field in access that has dates only in each of the records. When I loop through the rows in ADO.NET and display the fields on a web form, it appends 12:00AM after every date in the datagrid. Why does this happen and how can I modify the code to ensure that only the date in the access table displays???
 
¤ I am displaying fields from an access table using vb.net in a datagrid. One of the fields is a date/time field in access that has dates only in each of the records. When I loop through the rows in ADO.NET and display the fields on a web form, it appends 12:00AM after every date in the datagrid. Why does this happen and how can I modify the code to ensure that only the date in the access table displays???

You may want to use the Format function in your SQL statement to remove the time portion of the
field value.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access - Is it possible to repeat fields in a form? 1
INSERT Statement with Empty Date 1
Trouble entering empty date into Access table from ASP.NET app using ADO.NET 1
Datetime field in Data grid not displaying time 2
date not datetime in datagrid while reading from db 6
Access How to record date/time when specific field is modified in Access 2007 0
default values 4
Changing a Medium Time 5

Back
Top