Date format

[SidStunt]

Dear community,

All the data in my database is formatted as DD/MM/YYYY. 

This question is about meetings we have. The meetings should be link to other records. But when I want to link the meeting with date format DD/MM/YYYY in another table, the format is MM/DD/YYYY, which is quite confusing. Any idea how I could solve this?

There is a screenshot of the situation attached. 

[Sara]

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

Let me know if you have any other question 🙂

[SidStunt]

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?

[Sara]

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 🙂

[SidStunt]

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:)

[Sara]

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:

[SidStunt]

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'

[Sara]

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. 

[SidStunt]

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. 

[Sistema_Aotearo]

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'

)

2. If that doesn't work, it may be a glitch in the form builder. Try using the new form builder in the interface designer. I think there also may be an option in your form to convert your form to the new forms?