Forum Discussion
How to create proper Time zone convertions, including DST
Hi everyone,
I have a modified on and created on column, which show date time zones in UTC. However, I want to convert these date/times to W. Europe Standard Time (UTC +1), taking DST into account.
Can anyone help me with achieving this?
Thanks in advance.
Kind regards,
Fleur
in your warehouse keep all timestamps as UTC. Let the user's browser do the conversion to their local timezone (including DST)
5 Replies
- lbendlin
Super User
in your warehouse keep all timestamps as UTC. Let the user's browser do the conversion to their local timezone (including DST)
- v-prasare
Community Support
Hi Fleurclaes,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
- v-prasare
Community Support
Fleurclaes, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
- v-prasare
Community Support
@Fleurclaes, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
- FleurclaesRegular Visitor
v-prasare This worked, I made the conversion in the views instead of the entities.