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. 

[SidStunt]

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

 

[apianka]

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..