>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

You can use TTOD() to display only the date portion of a datetime var. This is on the VFP client right?

When sending to SQL Server, you can send only the date portion if you don't care about the time.