Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
how can I dynamically get the offset between utc and client.
The follwoing does not work
DateTimeZone.UtcNow()-DateTimeZone.LocalNow())
I want this to result in -4 as I am in EST.
Thank you in advance.
Solved! Go to Solution.
Some areas are offset by hours and minutes, hence the second line:
= DateTimeZone.ZoneHours(DateTimeZone.FixedLocalNow())
+ DateTimeZone.ZoneMinutes(DateTimeZone.FixedLocalNow()) / 60
@ronrsnfld many thanks, this is simply awesome.
Some areas are offset by hours and minutes, hence the second line:
= DateTimeZone.ZoneHours(DateTimeZone.FixedLocalNow())
+ DateTimeZone.ZoneMinutes(DateTimeZone.FixedLocalNow()) / 60
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 6 | |
| 5 |