Hi,Until today I thought that the default formatting of dates in the grid was the sameas setting the format property to "d" (shortdate).
By default the formatting seems to follow my regional settings (usually I justchange the language/country settings), but when selecting "Customize..." andthen setting the date format to for instance dd-MMM-yy it is not showing the dates in this format(should be 11-Sep-09, but it shows 11-09-09).
Of course I can set the format expliciltly in these columns to "d"(UltraGrid1.DisplayLayout.Bands(0).Columns(0).Format = "d")but I would prefer not to...
is this a bug, feature or am I misunderstanding something?
(I'm using version 8.3.20083.2082)
RegardsTomas
Hi Tomas,
You lost me somewhere in the middle paragraph here.
tomasedstrom said:but when selecting "Customize..." andthen setting the date format to for instance dd-MMM-yy it is not showing the dates in this format(should be 11-Sep-09, but it shows 11-09-09).
What "Customize..." are you referring to? Are you talking about the system regional settings?
The date cells use the system short date setting whenever possible, I think. But the DateTimeEditor cannot handle text like "11-Sep-09", so it probably falls back to some default when it encounters something like that.
My guess is that you probably have to set the Format on all of your date columns to "d", but it's not entirely clear to me from your post what exactly you want.
Thanks for the fast reply.
Yes, with "Customize..." I mean the button in the Regional and Language Options dialog which opens the Customize Regional Options and setting the date format there (instead of just selected a language/country option).
I just think it is strange that the grid is not using that setting by default, i.e. I thought that the default format for dates in grid columns was "d" (shortdate) since it behaves that way for most formats (but not dd-MMM-yy).If not, what is the default format?
I guess I have to set "d" myself to make it use the regional settings.
tomas.
By default, I think the grid uses the system settings. That is - the Short Date as specified in the regional settings on the machine.