Problem formatting date

[jonathan92]

Hi!, i'm having a little problem with dates again, when trying to show in the frontend the date, it always shows a day less then what the actual date should be, (i'm in Brazil by the way)

Data saved in the database:

Data returned:

How it's displayed:

This the code: {{due_date.formatDate('dd/MM/yyyy')}}

Wappler config:

I even tried this: td>{{due_date.toUTCDate().formatDate('dd/MM/yyyy')}} but got the same result

[Teodor]

Please check the following article, might be helpful:

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…

[jonathan92]

@Teodor

Please check the following article, might be helpful:

Thanks @Teodor figured out what was wrong, i was not saving in the db the necessary UTC of my country and also my db connection was using the legacy UTC, changed to UTC, and now it's woking properly.