Srinivas Yelamanchili (yelas1)
Senior System Architect
Pegasystems Inc.
yelas1 Member since 2014 76 posts
Posted: November 3, 2016
Last activity: December 9, 2016
Posted: 3 Nov 2016 13:38 EDT
Last activity: 9 Dec 2016 10:41 EST

Show Date only in particular TimeZone and format irrespective of user's locale

We have users all over the world and we have couple of issues with datetime columns in the report.

1. In the designer studio, report definition rule, what control can I use for a datetime property column to display only the Date part (DD/MM/YYYY) of the EST equivalent of the timestamp value. The value should always be Date part of the 'DateTime in EST' and irrespective of user's timezone.

2. If the user is creating/editing reports in portal, how can he/she select option to customize the displayed datetime format and timezone?

3. When a user with locale of UK submits a export-to-excel task report to agent (to run in background) the report has format mm/dd/yyyy (the server is located in USA). When the user opens this exported report in excel, the excel interprets the string as dd/mm/yyyy (and not mm/dd/yyyy) because of user's machine timezone. Wouldn't the agents that run export-to-excel task use User's locale for datetime format for export? Do the agent's always use the server locale?


Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.