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!

Dr. Martin Lisowski 1 day ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Joonas Linkola 14 hours ago
The following pages in the user guide have more information for future reference:

How do I format the date in M-Files?

Specifying Vault-Specific Locale Settings
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Date Formula issue

Contact Us

Schedule a Demo

Careers

Trust Center

Privacy Policy

Security Hall of Fame

M-Files Community

Support Portal

Help Center

Product Center

Download M-Files

User Guides

Product News