You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why OTBI Report export into csv does not keep custom formatted date in output csv file

in Reporting and Analytics for ERP

Title: OTBI CSV Export Does Not Retain Custom Date Format (MM-dd-yyyy)

Description:

Hi Team,

I have developed an OTBI Analysis report and configured the Invoice Date column with a custom date format of MM-dd-yyyy.

Expected Behavior

  • OTBI Analysis displays the date as MM-dd-yyyy.
  • When exporting the report to CSV, I expect the same format to be retained because the CSV file is used as the source for an external integration.

Actual Behavior

  • The CSV export ignores the custom formatting.
  • The exported file displays the date as dd-MM-yyyy.

For example:

OTBI Analysis

Exported CSV

03-17-2026

17-03-2026

02-20-2026

20-02-2026

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!