Hi,

What is the best way to display a date in a column of the grid with the following restrictions:

- Show date and time

- Localize date and time. In USA it should be MM/DD/YYYY but in UK it should be DD/MM/YYYY

- The column should be sortable

I've tried to set the EditAsType to DateTime but that removes the time portion. I've tried using a converter and printing the string in the proper format but then its not sortable. What is the best combination of options?

Thanks,

Mike