Hi All,
I am dealing with many timezones , I have a required to generate a SSRS report which uses the timezoneoffset based on the timezone name. The offset value returned should consider with or without DayLight Saving Time.
The input to the report is the date.
Can anyone please help me with the function to which i can pass date and it will return offset.
Input
Date: 2021-08-27
TimeZoneName- America/Chicago or Europe/Berlin
Output: Timezoneoffset -05/+1
Thanks.