Skip to main content
Answer

Dates not being displayed propertly with devexpress

  • May 7, 2024
  • 5 replies
  • 109 views

Forum|alt.badge.img+3

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?

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.

5 replies

Forum|alt.badge.img+3
  • Author
  • Vanguard
  • May 7, 2024

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. 


Dennis1690
Vanguard
Forum|alt.badge.img+4
  • Vanguard
  • May 7, 2024

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)


Forum|alt.badge.img+3
  • Author
  • Vanguard
  • May 8, 2024

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. 


Dennis1690
Vanguard
Forum|alt.badge.img+4
  • Vanguard
  • May 8, 2024

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.


Forum|alt.badge.img+3
  • Author
  • Vanguard
  • Answer
  • May 15, 2024

It turned out that setting the ReportContentLocale to ‘Dutch/NL’ did eventually work for our use case!