Time zone conversion in Cognos

[ambuj2k50]

<sup>The problem satatement is that The client want the timestamp a column to be changed according to timezone of the country the report is run.

For Ex: For a truck the sales time is -11.00 am UTC/GMT then if the report is run in india then the time should be displayed in the Indian time ( converting the sale time to IST ).

Considerations : Day light saving is also taken into consideration for conversion of time.
                        No java script or other tools should be used except core Cognos functions.
                        The Source timestmap is in UTC/GMT</sup>

[ambuj2k50]

Provide any matching works if u have experienced any....