Can't get rid of the time part of a date

[Jim in Arizona]

I have a simple query that queries an access database. One of the fields is
date/time.

I use this to extract the date from the field in access:
CDate(objDataReader("date")).ToString

When the webform is viewed, date and time both show up. (eg. 12/12/2005
12:00:00 AM) How do I get rid of the time?

I've also tried CDate(objDataReader("date")).Date.ToString

Is it the CDate function? Should I not be using that?

TIA,
Jim

 

[Karl Seguin]

It's ToShortDateTime() or something

Karl

 

[Jim in Arizona]

It's ToShortDateTime() or something

Karl

CDate(objDataReader("date")).ToShortDateString

That was it, Karl.

Thanks,
Jim

 

[Craig Deelsnyder]

CDate(objDataReader("date")).ToShortDateString

That was it, Karl.

Thanks,
Jim

I might also recommend the static String.Format method, where you can
define formats like MM/dd/yyyy, as opposed to relying on system settings
that could change. Just another option:

http://msdn.microsoft.com/library/d...f/html/frlrfsystemstringclassformattopic1.asp