Hello, we have a report where we show some dates. In the report configuration I am forcing the "dd-MM-yyyy” format, and with SQL I am getting the dates in this format as well. However, the dates are still being displayed as "MM/dd/yyyy” on the report. Has anybody else encountered this and solved it?
Solved
Dates not being displayed propertly with devexpress
- Vanguard
- 45 replies
Best answer by Niels Koop
It turned out that setting the ReportContentLocale to ‘Dutch/NL’ did eventually work for our use case!
This topic has been closed for replies.
- Vanguard
- 45 replies
Niels Koop wrote:
Hello, we have a report where we show some dates. In the report configuration I am forcing the "dd-MM-yyyy” format, and with SQL I am getting the dates in this format as well. However, the dates are still being displayed as "MM/dd/yyyy” on the report. Has anybody else encountered this and solved it?
The "MM/dd/yyyy” is being displayed on the report after it has been generated. The preview in DevExpress is showing the correct date format.
+4- Vanguard
- 25 replies
hi, I've ran into a simular problem. What you want to check is the following:
local pc settings (check timezone and location)
local pc keyboard setting (if set to US it can translate into mm/dd/yyyy)
Browser timezone and location settings
Browser keyboard settings (same as above, configuring this correctly will probably solve your issue)
- Vanguard
- 45 replies
Dennis1690 wrote:
hi, I've ran into a simular problem. What you want to check is the following:
local pc settings (check timezone and location)
local pc keyboard setting (if set to US it can translate into mm/dd/yyyy)
Browser timezone and location settings
Browser keyboard settings (same as above, configuring this correctly will probably solve your issue)
The report is generated in a subflow, so I think the local pc settings do not apply in this case?
I found an extended property called ReportContentLocale which I think is supposed to set the locale of the report. I set it to ‘Dutch/NL’, but it hasn't solved the problem for me.
+4- Vanguard
- 25 replies
Niels Koop wrote:
Dennis1690 wrote:
hi, I've ran into a simular problem. What you want to check is the following:
local pc settings (check timezone and location)
local pc keyboard setting (if set to US it can translate into mm/dd/yyyy)
Browser timezone and location settings
Browser keyboard settings (same as above, configuring this correctly will probably solve your issue)
The report is generated in a subflow, so I think the local pc settings do not apply in this case?
I found an extended property called ReportContentLocale which I think is supposed to set the locale of the report. I set it to ‘Dutch/NL’, but it hasn't solved the problem for me.
You need to know for certain and this is easily tested. I’d recommend giving it atleast a try.
- Vanguard
- 45 replies
- Answer
It turned out that setting the ReportContentLocale to ‘Dutch/NL’ did eventually work for our use case!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.