Hi,
We have had a similar problem and have created a SQL Server User Written Function that we refer to as a sql FUNCTION whenever the date only is required:

CREATE FUNCTION dbo.xfn__DateOnly (@vcDateTime datetime)
RETURNS VarChar(10)
WITH SCHEMABINDING
AS
BEGIN
RETURN CONVERT(VarChar(12), @vcDateTime, 101)
END
-----------
The above code creates the function in the local Database User Defined Function area as XFN__DateOnly (with source code). We then move the compiled function into the Master UDF as fn__DateOnly (without sourcecode).

Then in a SQL Stored Procedure
SELECT vcTransNoIN, dtIssuedIN = FN__DATEONLY(dtIssuedIN), etc.....

I hope this helps?