I have a custom report, which uses one of the available Product/Labor Custom Fields (Custom Field 11), which has a Data Type of “Date”.
In the Standard Report Designer, I have added that field to the report from the ReportExplorer.
I have then set the OutputFormat to “DD-MMM-YYYY”, hoping to get an output in the report of (for example): 01-Sep-2017.
The problem is, the report does not adhere to the OutputFormat, and just outputs “MM-DD-YYYY” which is the American format. It ignores any formatting conditions completely, as I have tried different types like “DD-MM-YY” and “DD-MM-YYYY” and it doesn’t work.
Nor does D-Tools recognise the OutputFormat “d” which should pull the date format from my operating system. But it still just outputs the American format, as my OS is set to “DD-MMM-YYYY”.
Does anyone have any ideas how to resolve this big?