>>>Sir I am trying to get maximum date from smalldatetime column
>>>For this I am using this command
>>>
>>>
>>>select max(convert(varchar(10),vou_date,103))as max_date from payments
>>>
>>>
>>>but it is not showing correct date.
>>>
>>>Please see attachment
>>>
>>>Thanks
>>
>>
>>select max(vou_date) as max_date from payments
>>
>>
>>PS: I don't know why but when I saw your question, I didn't see that Martina already replied.
>
>Thanks Martina, Now your query shows this result
>2017-07-05
>
>Sir I need your little more help
>
>How to convert 2017-07-05 to 05-07-2017 (British date)?
>
>Please help
You don't need it (on MS SQL server). Date is date.
You need set correct input mask on textbox in VFP.
MartinaJ