Print Page - Date format Excel vs CSV

Title: Date format Excel vs CSV
Post by: Zimbo_African_1980 on 16 Mar 2015 09:02:17 AM

I am running a report and exporting in CSV format. The date is coming out as '2015-03-05 00:00:00'
However when I run in excel i get '3/5/2015' which is what I want the date to show as.

Can someone help me with how I can maintain this format in the CSV file

Thanks for ur time guys

Ruzv

Title: Re: Date format Excel vs CSV
Post by: intrepid402 on 16 Mar 2015 01:56:23 PM

Try this:

cast([date item] as date)

or even better,
Click on the date item on report --> Data --> Data Format and click on Date. Here you can select how you want the date format to look like on the output.

Title: Re: Date format Excel vs CSV
Post by: Zimbo_African_1980 on 16 Mar 2015 02:34:19 PM

Thanks Intepid,
I tried that and it didnt work
I got the solution though

convert(varchaer(10), [dateitem],101)

Thanks

Title: Re: Date format Excel vs CSV
Post by: MFGF on 17 Mar 2015 05:17:01 AM

Quote from: Ruzvmun on 16 Mar 2015 02:34:19 PM
Thanks Intepid,
I tried that and it didnt work
I got the solution though

convert(varchaer(10), [dateitem],101)

Thanks

Hi,

convert() is not a Cognos function - I'm guessing it's something specific in the underlying database you are using as a data source?

If you wanted to be database-agnostic, you could use the Cognos extract() function to grab the year, month and day parts of your date, then cast them as varchar() and concatenate them with '/' characters.

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Zimbo_African_1980 on 16 Mar 2015 09:02:17 AM