Date format

Hi, you can change the format of the date on airtable in this way:

Let me know if you have any other question 🙂

Hi Sara! Thank you.

I know that's where you can change the format. But the format in the database is right! In every column it's DD-MM-YYYY. But when I link the table to another, the format gets changed into MM/DD/YYYY. Which you can see in the screenshot I attached... This seems to be a bug right?

Have you changed the formatting in the linked column too? 

because you have problem with the form's formatting, even if the column is a link field, you should change the formatting to European. Airtable automatically select the US format.

this should solve your problem. Let me know if this solve your problem 🙂

First of all, Thanks for diving into it with me.

The formatting in the linked column was already on Local DD-MM-YYYY. That's the formatting i wish for and what I set it on throughout our database. But suddenly when I link the record it just changes it to MM/DD/YYYY in the other table.

So here you see the database which I link to another table.

And here you see the link to the records above, but then the data format suddenly changed:

Thanks again! Would be great to have this solved:)

Hi, have you changed the formatting of "Link voortgangsgesp.."? . If you edit that column, you will see directly the "configuration" tab, but there is also a "formatting" section

as here:

Yeah I tried, but there doesn't seem to be a formatting option in the linked record. 

And below you find the settings from the table where the linked record 'belongs'

Okay, got it, you just use the link field, you need to create a new column with a "Lookup" field

and where I wrote "Table1, you have to write "Link voortgangsgesp.." and where I wrote "Date", you have to select the column on your primary table " Datum gesprekken", and after you have to change the formatting. 

Thanks. That solution does work a bit when I just show the value somewhere in a table.

However, I do need to link a 'Voortgangsgesprek' to 'Stunt vaardigheden'. We do that when we fill out a form. 

As you can imagine it's quite confusing for users who always use DD-MM-YYYY. Thereby, we do have multiple conversations at one time, but it does need to be linked to the right one. More information in there, like there is in the table And the right date format, would be great. 

Oh this does seem weird and strange behaviour. Not sure if this will work, but you can try either:

1. Use a formula to derive the the date in your first field. Possibly:

DATETIME_FORMAT(

  SET_TIMEZONE(

    {Date Field}, 'Europe/Amsterdam'),

  'DD/MM/YYYY'

)

Thanks. However I cant change the primary field in the table, since it's embedded in so many places in our interface. Users need to be able to change and add the datafield there, which will not be possible if it's a formula field. I could then let them use another data-pick field, but the primary field is always visible as well, which is not desirable.

It doesn't seem to be in the form builder. Because when I look in the table where the form is in, the table view also shows me the wrong format. See below.

Could you report this as a bug? Seems to be the case at least

I'm having the same problem, would be interested in a solution as well, as it's quite annoying for everyone working with the DB..