Make sure in the regional settings you set the date format to dd/MM/yy. make sure to use MM for month an not mm

>Hi Fred
>
>I have tried setting the PPC to English(UK) but it's doesn’t seem to make any difference to how the datagrid displays the date. I had already tried creating the date as a string in VFP using SUBSTRING(Dob,1,2) + "/" + ...
>and although it displays correctly it didn’t seem to sort the column correctly. I was only using two digits for the year maybe that affected the sort order?
>
>John
>
>
>>Make sure your regional setting on your PPC or Emulator is set to English(UK). That would fix the display. I'm in Australia and we did the same thing.
>>the other thinng you could concatenate your query string - SQL - using day(date)+'/'+month(date)+'/'+year(date) as Mydate
>>
>>>I am saving data to an xml file using CURSORTOXML() in VFP8. The date columns are formatted yyyy-mm-dd. When I read them into a dataset and display them in a data grid how do I format the column to display them as dd-mm-yyyy or dd/mm/yyyy?
>>>
>>>I am using the compact framework and C#.
>>>
>>>Thanks for any help
>>>
>>>John.