--- title: UTC to User Time Zone in Google Data Studio | GSuite Solved description: Transforming UTC timestamps in Google Data Studio made easy! Follow these steps to showcase Firestore data in user timezones seamlessly. image: https://www.c2cglobal.com/hubfs/Article%20Images/UTC%20to%20User%20timezone%20in%20Google%20Data%20Studio.jpg --- [![c2c logo blue](https://www.c2cglobal.com/hubfs/c2c-logo-blue.svg "c2c logo blue")](https://www.c2cglobal.com/) [Google Workspace](https://www.c2cglobal.com/articles/tag/google-workspace), [Data Analytics](https://www.c2cglobal.com/articles/tag/data-analytics) # UTC to User timezone in Google Data Studio By [Manish bhattarai](https://www.c2cglobal.com/articles/author/manish-bhattarai) | September 28, 2022 Hi All, I have a bigquery table which stores data from Firestore. Firestore stores all the timestamps in UTC timezone. Is there a best practice how I can display those timestamps in user timezone (not in UTC timezone) in Google Data Studio Dashboards? I would like to avoid converting the timestamp adding another field such as CreatedDateNY (using DateDiff).     **Best answer by ilias** you can try the following steps: - click on the **ADD A FIELD,** right down corner on Data Studio, - use Formula: DATETIME\_SUB(Order Received, Interval 2 HOUR), you can have your time difference from UTC here - click **SAVE** - click** FINISHED** - move it from the **Available Fields** to the **Dimension** --- ## Recent Articles [Data Analytics](https://www.c2cglobal.com/articles/tag/data-analytics) ## [Generative AI: Are You Behind?!](https://www.c2cglobal.com/articles/generative-ai-are-you-behind) Review the latest insights from the AI Readiness Report. By Bruno Aziza [Industry Solutions](https://www.c2cglobal.com/articles/tag/industry-solutions) ## [Make "Gen AI Work": Landscape, SLMs vs. LLMs, Cost & More...](https://www.c2cglobal.com/articles/make-gen-ai-work-landscape-slms-vs.-llms-cost-more) Discover the 5 metrics you need to know in order to be an exceptional CEO and Operator. By Bruno Aziza [Google Cloud Strategy](https://www.c2cglobal.com/articles/tag/google-cloud-strategy) ## [AI Cheat Sheet](https://www.c2cglobal.com/articles/ai-cheat-sheet) AI is no more and no less the drive to create robots with human minds so they can do everything we do and more. Use this cheat sheet to help decode the space. By Leah Zitter ## Subscribe to our newsletter Get the latest from C2C, direct to your inbox. [Subscribe](https://share.hsforms.com/1znKGo6ySS9uaRyvLQQzxRw4qbyr) ![c2c-logo-white-tagline](https://www.c2cglobal.com/hubfs/c2c-logo-white-tagline.svg "c2c-logo-white-tagline") C2C is the only peer-to-peer community built to support, connect, and educate Google Cloud customers across regions and industries so they can better harness the power of the cloud—and each other—to solve their biggest challenges and drive innovation. ©2024  C2C Global. All rights reserved. [Privacy Policy](https://www.c2cglobal.com/privacy) 20 N Wacker Drive • Suite 1810 • Chicago, IL • 60606 **Join over 60K members on C2C.** Let's connect! - [mailto:hello@c2cglobal.com](mailto:hello@c2cglobal.com) - - - [![X](https://www.c2cglobal.com/hubfs/twitter-x-icon-white.svg)](https://twitter.com/MeetC2C) ![](https://px.ads.linkedin.com/collect/?pid=2634489&fmt=gif)