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