Converting a stored value to a simple date

[mdsmith1]

I have solved this.
The answer is to create a text field and copy the date to the text field. Like what I have shown below:
UPDATE Invoices02 SET BDREMARK = CONVERT(DATE1, CHAR);
This will just the date component in the BDREMARK field with no time stamp.
Mike