How does NextGrid 5 determine the date format?
I have a text column which has the SortKind set to skDate. It's populated from a database. If the date is in local format (dd/mm/yyyy) then it sorts fine, but if it's in US format then it generates an invalid date error.
I assume it's using the date format for my locale. The problem for me is, when I grab a copy of a customer's database to investigate an issue, I keep getting errors when I try to sort by date.
It is possible to tell it programmatically the date format to use?
Thanks,
Steve