My Databse in Access has a date Field stored as short Date
i.e mm/dd/yyyy

All values stored in that field are in the above mentioned format
But When I display the date in ASP.net using a Datagrid control
I get the Date as
          6/18/2004 12.00.00 AM
How to get rid of this 12.00.00 AM ?

__________________
-.. -..

use formatting

formatdatetime(date_field,DateFormat.ShortDate)

Om Prakash

How can I incorporate this formatting in a query
          "select dt from Mytable"
wher dt is the date field of the database

Further , the resultant Data of the query gets bound to a
Datagrid

You can change the format in query as follows:
 Select order_date = convert(varchar,orders.order_date,101) from orders

You can always change the formatting in the datagrid

Please check the following thread:

http://p2p.wrox.com/topic.asp?TOPIC_ID=6590

Om Prakash

Did this work for you? If yes, please let me know. I tried dataformatstring in the datagrid property builder and it did not work, instead it displays "mm/dd/yyyy" on the page.
Thanks
Renu

Hi Renu,

Can you post that part of code here to see what you are missing.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay-
Here is the select command that I am using and still getting the time with the date:-

Me.SqlSelectCommand1.CommandText = "SELECT JName, JCity, JState, WorkDate = convert(varchar,tbl_jurisdiction.workdate,101) FROM tbl_Jurisdiction"

I also tried the following:-
In the datagrid's property builder, under columns I used the format "mm:dd:yyyy" in dataformatting expression. I am using VS.NET 2003.I am still getting the time.

Hi Renu,

Try this.

{0:MM-dd-yyyy}
OR
{0:D} as Dataformatting expression

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Wow! great! The first one works just fine.
Thanks for your help.

This is the Mpdified Selct Query
Select Format(MyDate,'dd-mm-yyyy')
where MyDate is the Date Field in the Database
This would display 23-10-2004

-.. -..