COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: arroju_venkat on 19 Nov 2008 08:35:32 AM

Title: Date Format While Exporting Report To CSV
Post by: arroju_venkat on 19 Nov 2008 08:35:32 AM
In a report date field is in YYYY-MM-DD format and when the report is run in HTML format format appears as YYYY-MM-DD but when the report output is exported to CSV ,date format seems to change i.e displaying DD-MM-YYYY rather than YYYY-MM-DD
Any ideas how to make the format constant in both the format
Title: Re: Date Format While Exporting Report To CSV
Post by: Suraj on 19 Nov 2008 12:27:12 PM
Did you try setting Format as Date and specify the ordering?
It gives me same format in html and excel when I set those formats.