Convert Timestampz to date or format it doesn't work

[franse]

Hello @jonathan92 and welcome to the community!

First of all, take a look at this:

Date and Time Settings for NodeJS

Intro In this tutorial we will explain the different date and time settings available for NodeJS and how to handle time zone options. Server Time Zone You can set the server time zone settings depending on your needs. The settings depend on if your are using Docker or not. Using Docker When you are using Docker, then you can adjust the server time zone settings in the target settings: [Screenshot_2] You can select UTC or your specific time zone from the list: [Screenshot_3] Not Using D…

After reading the topic above, then:

Date toDate: (Second one) has an extra ")", you should remove it so:

{{sc_list_reviews.data.query_reviews.data[0].review_date.toDate()}}

On Date toDate.FormatDate: (Third one) try:

{{sc_list_reviews.data.query_reviews.data[0].review_date.formatDate('dd/MM/yyyy')}}