Elastic report different default DateTime format for Excel

[kcks66]

Hi Mikhail,

My elastic report after generated excel datetime default is [02/07/2024 10:00:00].
How to make default format after generated to become [Tue, 2 Jul 2024 10:00:00 AM]?

Thank you.

[Mikhail]

Hi,
It may depend on Rapid SCADA culture that is set in the Administrator application.

[kcks66]

Hi Mikhail,

Pls advice for which file or location contain the culture or locale setting?
Thank you.

[Mikhail]

Hi,

SCADA\Config\ScadaInstanceConfig.xml

[kcks66]

Hi Mikhail,

I change the culture from original en-GB to many such as en-US, en-SG, en-MY, etc. Somehow I can get is [7/2/2024 10:00:00 AM]. I still couldn’t get [Tue, 2 Jul 2024 10:00:00 AM].

If I manually change the DateTime inside Excel Format Cell by using custom code [ddd, d mmm yyyy hh:mm:ss AM/PM], it worked.

Pls advice for can I use something like [ddd, d mmm yyyy hh:mm:ss AM/PM] into Rapid SCADA Administrator application to make it happen?

Thank you.

[JurasskPark]

@kcks66
Display of the time format (if the OS is Windows) depends on the setting Control Panel – Regional Options – Advanced Options – Date tab – Date format – full date format.
What can you choose there?

[Mikhail]

In Elastic Report, short date and time format is used. If you compare en-GB and en-US, you can see the difference.

[kcks66]

Hi JurasskPark,

I can choose as below:

https://ibb.co/FJTsfkb

[kcks66]

Hi Mikhail,

Can I change from short date and time to long date and time in Elastic Report?

[Mikhail]

Hi,
Unfortunately, there is no such option.

[Author]

Posts