An Azure service for ingesting, preparing, and transforming data at scale.
Hi @arkiboys ,
Would you please try the following. Thanks!
fromUTC(currentUTC(), 'Europe/London')
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I am usingthe following expression but I see it showing one hour behind.
I would like to see the current uk datetime
This is what I am using at present inside the dataflow --> fromUTC(currentUTC(), 'GBT')
Thank you
An Azure service for ingesting, preparing, and transforming data at scale.
Answer accepted by question author
Hi @arkiboys ,
Just to clear is fromUTC(currentUTC(), 'GBT') is one hour behind , then fromUTC(currentUTC(), 'Europe/London') is the expression which you are looking for ( as suggested by @Nasreen Akter , Thanks @Nasreen Akter ) .
I am just adding the screenshot for more clarity for other team members .
Please do let me know how it goes .
Thanks
Himanshu
-------------------------------------------------------------------------------------------------------------------------
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how