Troubleshooting
Problem
A date in an Impromptu report is displayed in the format DD/MM/YYYY or DD.MM.YYYY (for example: 12/31/2005 or 01.10.2004). When the report is exported to a CSV, the date is in the following format: YYYY-MM-DD HH:MM (for example: 2004-10-01 12:00). Why is this happening? How is the date format determined, when saving an Impromptu Report as a text or CSV file?
Resolving The Problem
Use the Save as XLS with Format option in the Impromptu Save As dialog.
When exporting data to a CSV file from any of Impromptu, Impromtu Web Reports (IWR) or IBM Cognos Query, the date format used is the international ISO standard, which is:
- YYYY-MM-DD HH:MM:SS:TH (24 hour clock) for Date Time data types
- YYYY-MM-DD for date data types.
You can also create a calculated column to convert the date into a formatted string, using the day, month and year or substring functions. For example:
(substring(date-to-string(date),7,2))+ '-' + (substring(date-to-string(date),4,2))+ '-' + (substring(date-to-string(date),1,2))
Historical Number
1014958
Was this topic helpful?
Document Information
Modified date:
28 November 2022
UID
swg21350310