Date and Time functions to UTC time

[Jerry]

In the Designing Reports doc, it says:

 Now() Returns the current date and time on the computer processing the report, expressed as the local time.

I have a server to generate the report,  so the Now() = server local time.   Server can be deployed to anywhere ( UTC offset can be any value)

I want to show client local time Now() in the report.  How can I implement it? 

[Stef]

Hi Jerry,

About dates in Telerik Reporting:

1. In reports you can use the built-in Today and Now functions, which are evaluated on the server machine where reports are processed and rendered;
2. When you use the HTML5 Viewer, the user selects local dates which we convert to UTC dates before submitting them to the server.

Thus to avoid displaying the server's time, you can add an Integer report parameter adding the hours to the Now() value. The parameter's value will be the UTC offset.
Other approach will be to use a DateTime report parameter instead of Now() in the expression. The parameter's value can be set in the report's constructor or through the client to an adjusted DateTime value.

We also recommend storing all dates in UTC with offset.

Regards,
Stef
Telerik by Progress