How do I format the date in M-Files?

The Date data type of a property is used to show a date and time as a property value. To change the format, change the date and time format settings of the client computer's operating system.

Note: These instructions are for Windows 10, but the procedure is highly similar for other Windows versions.

Do these steps on the M-Files client computer to change the date format:

  1. Right-click the Windows Start button and select Settings.
  2. Select Time & language > Region > Additional date, time, & regional settings.
    Result:The Clock and Region window is opened.
  3. In Region, click Change date, time, or number formats.
    Result:The Region dialog is opened.
  4. On the Formats tab, click Additional settings.
    Result:The Customize Format dialog is opened.
  5. Open the Time tab and enter a format to Short time.
  6. Open the Date tab and enter a format to Short date.
  7. Click OK to close the Customize Format dialog.
  8. Click OK to close the Region dialog.
All the properties that use the Date data type now use the format that you have specified here.

How do I format the date on the M-Files server computer?

Many M-Files Server operations use date and time information. For example, script executions and PDF conversions. The date and time settings of the M-Files server computer's system account specify how dates and times are formatted in such operations.

Tip: If you cannot change the locale settings of the server computer, you can use these instructions to override the server's locale settings: Specifying vault-specific date and time format for automatic values and notifications. This can be useful, for example, when you use M-Files Cloud.

Do these steps on the M-Files server computer to change the date and time format:

  1. Right-click the Windows Start button and select Settings.
  2. Select Time & language > Region > Additional date, time, & regional settings.
    Result:The Clock and Region window is opened.
  3. In Region, click Change date, time, or number formats.
    Result:The Region dialog is opened.
  4. On the Formats tab, click Additional settings.
    Result:The Customize Format dialog is opened.
  5. Open the Time tab and enter a format to Short time.
  6. Open the Date tab and enter a format to Short date.
  7. Click OK to close the Customize Format dialog.
  8. Open the Administrative tab.
  9. Click Copy Settings.
  10. Enable Welcome screen and system accounts.
  11. Click OK to close the dialog.
  12. Click OK to close the Region dialog.

All dates and times generated by the M-Files server computer now use the format that you have specified in the steps here.