If you’ve got your dates and datetimes stored as UTC in your database, but want to show the local time value on your reports in SQL Reporting Services, there is a simple solution for this!

 

Change the expression for the filed to the code below :

=System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!DateTime.Value)

 

This converts your UTC datetime field to the local time zone value.