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.