When uploading an Excel file, it adds one day to the date

Queries and Resources
1

Hello everyone

I have a window where I upload an EXLEL file with a button, and for some strange reason when the RETOOL interface picks up the table, it adds one day to the date that appears in the Excel table.
I tried playing with the different date formats to no avail

this is my EXLEL file

image
image740×107 5.11 KB

And this is what he shows me in the table after the upload

image
image776×172 10.4 KB

And this is the definition of the column in the table
image

As you can see the date in the excel file is 8/29/2021 and 8/30/2021
And he perceives it as 8/28/2021 and 8/29/2021

Does anyone have an idea why this happens?

2

Is it possible to change the Retool column to Auto?
Perhaps, depending on there is a localization issue occurring as it relates to timezone?

3

In new table component, you can Manage your timezone

image
image288×835 26 KB

1 Like
4

The issue is resolved
The problem was unfortunately that the clock on my Ubuntu system was not set
Thanks everyone for the help

5