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?
When a user picks the Date control when creating reports, will the report in the portal use from user's timezone equivalent or server's timezone? If it always translates to user's timezone, how can we force to show that always in EST?