>is there an easier way to get the date part of a datetime field than using the year(), month() and date() funcitons ??


Hi Hans,

Try

DECLARE @dt datetime
SET @dt = getdate()
-- 0 represents the base date (01/01/1900) in SQL Server
SELECT DATEADD(dd,DATEDIFF(dd,0,@dt),0)

Or you can use CAST and CONVERT functions.

SELECT CAST(  CONVERT(char(10), getdate(),111) AS datetime)