Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
175
DateTime Format With Localization And Sorting
posted

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