The date format changes on detailed view

[GPYApp]

Hello,

I have a virtual column that shows me the dates on which a student took (or will take) a class.
When I am in the "Form View" the date appears in dd-mm-yyyy format (this is the one I need). When I enter "Detail View" the date appears in mm-dd-yyyy format.

I checked and in "Table Settings" I have my country selected ✔️
I add some screenshots so you can see better.

 

 The first SC is as the data is selected and shown in the Form View. The second one is how is showed in the Detail View.

"Fecha Clase" is using the Select() function in a Virtual Column to get to those dates.

Thank you!

[Denny774]

Hey,

make sure the table as well as the gSheet are using the same locale.
Also, you can do this select statement:
TEXT(SELECT(Table[DateColumn]), "dd-mm-yyyy")

Cheers

[GPYApp]

Hello! I get this error using that formula. I imagine it is because I am trying to format a "list" and not a text.

On the other hand, I checked and Google Sheets and is using the same locale.

Any other idea? Maybe it is a bug? Thanks

[GPYApp]

Someone has a solution? I discovered that the date format is changed when using a Virtual Column.