How to create proper Time zone convertions, including DST

[Fleurclaes]

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

[v-prasare]

@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

[Fleurclaes]

@v-prasare This worked, I made the conversion in the views instead of the entities. 

[v-prasare]

@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]

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

[lbendlin · Accepted solution]

in your warehouse keep all timestamps as UTC.  Let the user's browser do the conversion to their local timezone (including DST)