Convert Timestampz to date or format it doesn't work

[jonathan92]

I have a field in the database that storage the date (timestamp with time zone) however when retrieving that field in the front end without any transformation the data shows, the output is like this (2023-05-20T00:00:00.000Z), but if i try to modify it to a more user friendly format it doesn't work, toDate or formatDate

Wappler version: 6.8.0
Server: nodejs with docker
Database: Postgres v15.3

Thanks in advance!

[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')}}

[jonathan92]

Hi franse, thanks for your reply, the extra " ) " i removed, but forgot to take another screenshot before uploading, did the configurations as mentioned in that post but the only one i can't find is the database timezone handling, and it still doesn't work, i even put on the page a date picker with time and displayed it's value, but when i try to format it then nothing appears