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

[@Darok6699]

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! ☺️☺️

[@josephcruz4736]

Thank you for this!

[@danalyser]

You're so welcome! :)

[@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?

[@pablolube]

Estaba buscando esto! Muchisimas gracias, te ganaste un suscriptor

[@hasanmougharbel8030]

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.

[@danalyser]

Hi Hasan, nice to meet you! Yes, logically this would happen. Usually database would have a auto-generated ID to make sure each records is unique. :)

[@juanpauloalmazan2997]

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

[@ppiddishubaceh8308]

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

[@danalyser]

Hi there! Thanks for the great question! assuming you're using time series chart, you may go to STYLE and change "X-axis" range to "Range by Date Range".

[@ariprayogo7676]

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

[@Iamgroot14344]

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

[@danalyser]

Hey 👋 thanks for the suggestions! I’ll consider it for future content ! :)

[@renzoarmandovillalobostipa4823]

me sirvio gracias

[@atikarusykuncoro4802]

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

[@ArlieSoreno-fb8bc]

danalyser how to put month in short name?

[@hhbbhvvbjhbbyjj]

awsome thanks!!!!!!

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

[@BIAnalyst-nz5qq]

i have the same problem

[@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. kzbin.info/www/bejne/hHjHhoOBn7KYn5I