>eric,
>thanks for you help, but i did'nt quite ask the question correctly.
>
>im using sql server, the field in question is defined as a datetime data type.
>
>in my vfp6.0 project i have a remote view defined to access this data on a
>form.
>
>the field is put on the form in a textbox. i need for the input mask and/or
>format to show and accept only mm/dd/yy. i do not want the century or time
>to be part of the input mask or format.
>
>frank
I don't use SQL Server but with Sybase I would just replace the call to the datetime() function in my example with the actual value returned from SQL Server. You can verify if VFP sees the value as a FoxPro datetime datatype by checking it with type().
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California