Hi

Im trying to remove the "time" from a datetime field in a Table on SQL sever 2000

Im using this from today
(convert(datetime,floor(convert(float(24),getdate()))))

which is working for any records added to the Database from today

anyone got any tips for removing the time from records already in the Database, keeping the original Date?

Thanks