File Content Extraction 25.2
Filter SDK C Programming Guide

# Specify Date and Time Format on UNIX Systems

In Microsoft Excel you can choose to format dates and times according to the system locale. On Windows, File Content Extraction uses the system locale settings to determine how these dates and times should be formatted. In other operating systems, File Content Extraction uses the U.S. short date format (mm/dd/yyyy). You can change this by specifying the formats you wish to use in the `formats.ini` file.

To specify the system date and time format on UNIX systems

- In the `formats.ini` file, add the `[LocaleSetting]` section, and specify the following options:

  - `SysDateTime`. The format to use when a cell is formatted using the system format including both the date and the time.
  - `SysLongDate`. The format to use when a cell is formatted using the system long date format.
  - `SysShortDate`. The format to use when a cell is formatted using the system short date format.
  - `SysTime`. The format to use when a cell is formatted using the system time format.

  NOTE: These values cannot contain spaces.

  For example:

      [LocaleSetting]
      SysDateTime=%d/%m/%Y

  In this example, dates and times are extracted in the following format: 28/02/2008

  The format arguments are the same as those for the `strftime()` function.

  See http://linux.die.net/man/3/strftime for more information.

Copyright 1997-2025 Open Text
Version 25.2 | Last updated April 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: File Content Extraction 25.2

Topic Title: Specify Date and Time Format on UNIX Systems