>Hi Vladimir,
>
>>I used different convert options for it
>>Look syntax of MS SQL server convert function
>
>I try this way,
>
>.Open("SELECT *, convert(char(10),d_datacriac,102) FROM &lcTable where c_codigo= '"+lcChv1+"'",lcConn)
>
>
>In form, the form field is bound like
thisform.oRS0.fields('d_datacriac').value
>
>And i get the same to type YYYY-MM-DD 00:00:00, nothing is converted, what could be wrong here?
>
>
>Thank's
>
>João Batista
Put some name for converted field
.Open("SELECT *, convert(char(10),d_datacriac,102) as d_d FROM &lcTable where
Use this name, when you get this field on the form
I use convert fuction very active, because Russian sequence of the time is different from the standard one, and the order must be also different
So, regulary I am forced to use 2-3 converts in one select for same field to provide all this
Bext wishes, Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.