Date format in ACCESS database

[Johnkokk]

Ok, here is a silly one. I have a ms access database that i want to manipulate through a datagridview in my VB .net app. I have defined the appropriate field in the database as DATE/TIME, because i will make date filtering on the records through sql in my app. Now when i add any record through my app, i always get a date format like 17/2/2010 0:00:00 in the datagridview, obiously because this is the format of the access database which is databound to the grid. I DO NOT want the time part. Is this doable or i am stuck with it ? Thanks

[Lost User]

Johnkokk wrote:

i always get a date format like 17/2/2010 0:00:00 in the datagridview, obiously because this is the format of the access database which is databound to the grid.

Go to the offending table and open it in the design-view. Click on the DateTime-field and go to the properties. There's a Format property that controls how the data of this particular column is formatted.

I are Troll :suss:

[thatraja]

you can solve it by two ways. 1. Using the date column datatype's format property in Access database.(various formats like General Date, Long Date, Medium Date, Short Date, Long Time, Medium Time, Short Time) 2. using the DataFormatString property of bound column in gridview. (examples: DataFormatString="{0:MM-dd-yyyy}", DataFormatString="{0:MMM dd, yyyy}", DataFormatString="{0:ddd MM, yyyy}", etc )

thatraja

---

Tips/Tricks|Brainbench certifications

[Luc Pattyn]

:confused: I would assign the responsibilities to the right parties: let the database hold the data and not worry about formatting, and let the application take care of the formatting; in this case, tell the DGV what format is to be used.

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.

---

[Johnkokk]

I've already tried setting the formating in the database field. It doesn't work

[Luc Pattyn]

Hi, you can set the formatting specification for each individual column of a DataGridView. Here is a C# example:

dgv.Columns[1].DefaultCellStyle.Format="dd MMM yyyy";

which works fine as long as the field bound to that column is a DateTime (and not a string!) :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.

---

[Johnkokk]

<b>2. using the DataFormatString property of bound column in gridview. (examples: DataFormatString="{0:MM-dd-yyyy}", DataFormatString="{0:MMM dd, yyyy}", DataFormatString="{0:ddd MM, yyyy}", etc )</b> That worked, thanks

[Lost User]

+5, and goodmorning; You're right. The native grid in Access 2007 doesn't support that, but if it's a VB.NET application than he's using a DataGridView - and not a grid on a native Access-form :)

I are Troll :suss:

[Luc Pattyn]

Good morning Sir to you too. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.

---