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)
 
Back
Top