Hi!
I display a date column in my grid, but for some reason, the year gets messed up - instead of 2008 I get 0008 , instead of 2012 i get 0012 and I don't understand why...
Here's a screenshot:
And my system settings :
any ideea on why this is happening ?
Thank you!
What is the DataType of these columns?
What other properties might you be setting on these columns? Format? MaskInput?
I do not apply any alteration to that column. I just pull the data from the database, and set the binding source. I must mention that this happens only on the production machine - on the development everything works fine. The difference between the two are the OS (WinSrv2003 for production and Win7x64 on development) and the regional settings MM/dd/YYYY on prod and MM.dd.YYYY on devel.
It's a DateTime column - it's loaded from an oracle database - DATE column.
Let us know if you have further questions.
You were right mike, the porblem was coming from the database - an oracle issue. Thank you for your help and support!
Hi,
The operating system should not matter, but the regional settings might. Have you tried changing the regional settings on your development matching to the same as those on the production machine to see if you get the same problem?
If you are certain you are not applying a format or an editor or a mask to the column, then I think this must be directly related to the regional settings - that's the only factor that would be different from one machine to another.
Also, what version of the controls are you using? You might want to consider getting the latest service release just to see if that fixes it. Maybe this was a bug in some old version of the controls.