Timeline view not recognising date type

Hi. I’m in Australia (yes, it exists) and the document locale is set to my timezone.

I have added 2 date columns for start and end with format dd/mm/yyyy. The columns appear to be recognised as date types. The values are data (not a formula).

Screenshot from 2024-01-15 18-13-59

Screenshot from 2024-01-15 18-14-09

Configuring the timeline range however does not work. Can anyone please suggest how to resolve this issue?

Screenshot from 2024-01-15 18-13-30

Thanks for reaching out and sorry to hear you’re running into this issue, @Nicholas_Keown . Would you mind sharing your doc with us so we can take a closer look at the issues you’re encountering?

You can do that by going to Share in the top right-hand corner, clicking the button in the top right (to the left of the “X”), and toggling on Share with Coda Support (the gif below shows how to do this).

Afterward, please send us a link to that doc in your response so we can take a look for you! :smiley:

Thanks.

Here is the link to the page with the issue: https://coda.io/d/Hatchery-Hub_d8eGfpXWL4Z/Staff-Leave_suuX9#_luti4

Hey @Nicholas_Keown! For Coda column types, we don’t overwrite the data that you enter when you choose to show a date or a date and time a certain way. We only display it in that format. It’s possible that your dates are actually entered in different formats as underlying values (e.g. some might be 12-10-23 vs some might be 12/10/23, etc). You can see this if you change the column type to “Text”.

If that’s the case, a workaround is to create a new column and add a formula to force those values to be shown as consistent dates:

[Column Name].ToDate()

Then, spot check to make sure that the original dates and the new column dates look the same. Then just copy/paste from that new column over to your original column.

That should use the correct values and all the same date type, which should get you sorted!