How to - Format Date / Datetime / Timestamp with FORMAT_DATETIME() Formula - 5 EXAMPLES INCLUDED 🎉

Have you ever wonder how to change your date formatting in Data Studio ? This tutorial covers just that! With Format_Datetime() Formula, as long as your field is a date field, you can use this method to transform and extract date parts/abbreviations easily!

PS: I intended to include just 2 examples, but made a careless mistakes in the end. So do join me and see how the troubleshooting is done. (Pretty spontaneous tutorial I have here, sorry about that!)

R E S O U R C E S

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?

👉 Shop Danalyser Templates Collection

#GoogleDataStudio #Danalyser

T I M E S T A M P
00:00 Datetime Formatting
01:20 Format_Datetime Formula Explained !
03:12 Example 1
05:50 Limitations & Alternative For Time Series Chart
07:15 Example 2 (Failed Attempt 😅 Sorry!)
09:28 Example 3 - Custom Format
11:30 Example 4 - Adding Weekday Name
13:28 Example 5 - 24 Hour Time Format

⭐️ NEW TO GOOGLE DATA STUDIO
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨

F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!

[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]

--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------

💌 W A T C H N E X T
⚈ Show current date in dashboard

⚈ Export Data from Data Studio

⚈ Automation in Data Studio (Email Delivery)

[Darok]

Thank you so much for the time you spend making this video you saved me :D

Gracias!

[danalyser]

I am so sorry I missed the premiere! 😅😅😅 was working on some interesting project 😅😅 sorry for those waiting! Let me know if you have any questions in the comments! ☺️☺️

[pablolube]

Estaba buscando esto! Muchisimas gracias, te ganaste un suscriptor

[staticalmo]

I have a column formatted as "%d/%m/%Y %H:%m
If I use TODATE(Create Date, "%d/%m/%Y %H:%m", "%Y/%m/%d"), the time series charts show a lot of points in the future that don't exist. I tried different solutions but nothing works. Did you ever havve this very EU problem?

[ariprayogo]

Hi Danalyser, can you show me how to break the time per 30 minutes. it will help thanks

[hasanmougharbel]

Hey there, glad to meet again.
I learned about timestamp as a date data type.
My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen?
Thanks for taking care of this.

[Iamgroot]

Hi Danalyser, can you create a tutorial in making side by side bar chart of current week and previous week?

[juanpauloalmazan]

good day, is there a way for us to convert isoweek to weekdate starting monday.

[atikarusykuncoro]

the result will be String. Any way to create the result to be datetime?

[ppiddishubaceh]

hi Danalyser, is it possible to restrict the day only from Monday to Friday? I dont want to put Saturday and Sunday since there wont be any input in the weekends. tks

[ArlieSoreno-fbbc]

danalyser how to put month in short name?

[aamiraleem]

I tried hours in looker studio reports with GA4 the below formula, but it is not working

FORMAT_DATETIME("%H:%M", Date)

It is returing 00:00

Can any one can help me what it is not working in looker studio with GA4?
And why it is returing 00:00

[RitvijKacha]

Hey Danalyser, could you please demo, how can I show date time which changes continuously in dashboard and not only page is refreshed in data studio? I've already gone through below video of your but it changes time only when page is refreshed.