Is there anyway i can only input a date in a datetime field. i absolutely do not need or want the time...please help. this is really frustrating.

The DateTime datatype by definition includes both a date and a time. You cannot change this. You can, however, choose to simply ignore the time portion of a datetime column (or perhaps more properly, consider all the time values to be midnight).

For example:

UPDATE yourtable SET yourdatetimecolumn = '20060617' WHERE ...

will set the time portion of the datetime column to midnight on June 17, 2006. Whereas:

SELECT CONVERT(101, yourdatetimecolumn, char(10)) FROM yourtable WHERE ...

will simply discard the time portion of the datetime column and return the value as a string in the form mm/dd/yyyy.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

It is still a date-time field, you simply ignore the zero time value (wasting space). If you want just a date with no time field try Mysql or Postgresql.