We have upsized our tables to a SQL server and the DATE columns have been converted to DATETIME data type. This change has annoyed our secretaries and we are looking for a simple solution. I have experimented with FORMAT and INPUTMASK but have not been able to get rid of the time portion of the data.

How is everyone dealing with this change?

…tim