Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Convert datetime from UTC to EST

Hi, the datetime column imported from Salesforce has automatically changed to UTC timezone as default. How to convert it to EST by considering the Daylight Saving too?

Need Help

Pragati11
4 years ago
HI Anonymous ,

There are few existing threads on this forum for this question:

https://community.powerbi.com/t5/Desktop/Custom-Query-Function-to-convert-UTC-to-EST/td-p/1106780

https://community.powerbi.com/t5/Desktop/Converting-UTC-to-EST/m-p/1253745

You can also check following blog on handling timezones in Power BI:

https://powerbitalks.com/2020/08/convert-utc-into-local-time-zone-po.html

Thanks,

Pragati

Pragati11

Super User

4 years ago

HI Anonymous ,

There are few existing threads on this forum for this question:

https://community.powerbi.com/t5/Desktop/Custom-Query-Function-to-convert-UTC-to-EST/td-p/1106780

https://community.powerbi.com/t5/Desktop/Converting-UTC-to-EST/m-p/1253745

You can also check following blog on handling timezones in Power BI:

https://powerbitalks.com/2020/08/convert-utc-into-local-time-zone-po.html

Thanks,

Pragati

Forum Discussion

Convert datetime from UTC to EST

Related content

Convert DateTime to Date

Converting Epoch Datetime into regular datetime format

Convert DateTime to Table missing

Convert DateTime to Local Time

Convert bigint to datetime