Zahid,
another way:
If you no need the partitition of time data,
you can bring down data from SQL with cursor adapter with schema, where this column is type 'Date'
HTH


I want to convert DateTime format of SQL Server to only Date in Vfp.
>I know i can use CONVERT() in SELECT statement but i want to control i with FORMAT or INPUTMASK.
>I m using SQL Pass Through to bring down data.
>-----------
> After Connecting to SQL Server. save handle to => hConn
> =SQLEXEC(hConn, 'Select * from invoice', 'inv')
> after setting updatable all fields of INV cursor.
>*
> thisform.text1.controlsource = 'inv.inv_date'
> thisform.text1.format = 'E'
>------------
>I have tried thisform.text1.value = {} before setting control source to inv.inv_date but it didnot work.
>
>Looking for you expert suggestions.
>
>Thnx in Advance

_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst