Question

7
Replies
1777
Views
JohnL881 Member since 2013 15 posts
Infosys
Posted: 5 years ago
Last activity: 5 years 2 months ago
Closed
Solved

DateTime Format on Scheduled Report in Excel

Hello everyone,

we are facing an issue regarding DateTime Value Formatting in a Report Definition.

Marked Properties are of type DateTime.

Report.png

And Format Values is configured this way:

Report2.png

When I run this report manually (my OperatorID's default locale is set to en_US), I get the expected result, also when exporting to Excel

Report3.png

Excel.xls.png

We have set up a shedule task to email this report to a list of users on a daily basis. Report data is set to be sent as an Excel Spreadsheet:

schedule.png

The attached file does not contain tthe desired format of the DateTime Properties. No matter how we configure the report, the output always uses following format:

excel2.png

What steps or settings do we have to consider to have the desired format in our email attachment?

Some, maybe useful information:

The LANG environment variable is set to: en_US.UTF-8

Thanks a lot!

***Updated by moderator: Lochan to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Reporting
Moderation Team has archived post
Share this page LinkedIn