Date Formula issue

Hello,

I’m encountering an issue with the date formatting in my data. The dates seem to be shifted or displayed differently in various properties, as you can see in the attached pic. For example, I have a date listed as "09/01/2025," but in the title, it appears as "1/9/2025."

Additionally, I’ve added the correct property for the date, but the issue persists. Could someone explain why this is happening and how I can fix it? btw I have already tried changing the date format on my PC, but it didn’t work. Is there another solution someone could share to help me resolve this?

EDIT:

we find the solution in M-Files Admin Configurations:

the case solved.

thanks!

Parents
  • If I had to guess is that it's the difference between regional settings on your M-Files server vs. your M-Files client(s). Automatic value calculation is done on the server and it becomes a string after it's done. Display of DATE properties on the metadata card is done on the client and depends on the client's regional setting.

    If I had to suggest how to use dates in a title, I would use the ISO date format https://en.wikipedia.org/wiki/ISO_8601 , i.e. "2025-01-09" to encode January 9th, 2025. That way you don't have the ambiguity between US and European interpretation and also users can sort objects by date by sorting them alphabetically by title.

Reply
  • If I had to guess is that it's the difference between regional settings on your M-Files server vs. your M-Files client(s). Automatic value calculation is done on the server and it becomes a string after it's done. Display of DATE properties on the metadata card is done on the client and depends on the client's regional setting.

    If I had to suggest how to use dates in a title, I would use the ISO date format https://en.wikipedia.org/wiki/ISO_8601 , i.e. "2025-01-09" to encode January 9th, 2025. That way you don't have the ambiguity between US and European interpretation and also users can sort objects by date by sorting them alphabetically by title.

Children
No Data