Hi Sergey,
Thank you for your help. I didn't realize you can change the type in the view. I will check out the view designer on how to do it (I presume that that's where you change it).
>Hi Dmitry,
>
>You can change the type of this column to the date in the view.
>
>>In the SQL Server database I have a column type SMALLDATETIME.
>>I created a remove view to the table with this column. Now, when I display this column in the VFP form it shows both date and time. How do I make the textbox to show only the date portion of the field?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham