How do I change my date formats from MDY to DMY?
  • 02 Jun 2023
  • Contributors
  • Dark
    Light
  • PDF

How do I change my date formats from MDY to DMY?

  • Dark
    Light
  • PDF

Article summary

Where in FIMS do we configure the way a date is displayed?  How do I change from American to European date formats?

Answer:
The date information is stored in the FIMS database in American mdy format.  However, with a line added to the found\configfiles\wfound.pf file, the display of the values can be changed to different formats.  In particular, it can be changed to the European or British format of dd/mm/yyyy. This change will impact the display of all dates displayed and printed and exported. Remember the data is still stored the same way, it is just the display that changes.

In FIMS, once the format of MDY,DMY, YMD, or other variation is defined, the system will handle the 2 or 4 digit year and the other presentations of the date appropriately.  All you need to define is the order of the date elements.
 
  1. To change from one order to another you would edit the wfound.pf file.
  2. This is currently found in the npo\found\configfiles folder
  3. Open the wfound.pf file in notepad and either modify or add the existing -d parameter.
  4. If there currently is no line you would add a line like:
-d mdy

would be the standard USA display of 01/31/16

-d dmy

would change this to 31/01/16 for January 31, 2016.

     5. Close FIMS and re-open it and dates should conform to the new order.


Was this article helpful?