If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date format changes when emailed as CSV attachment

Started by atomicfox, 14 Mar 2011 03:51:39 PM

Previous topic - Next topic

atomicfox

I have two date values setup in my report and have the Data Format setup to deliver the fields as 'JAN-01-2011 20:00:00' The report works fine and the date comes up correctly if I run the report directly from Report Studio, however I have the report scheduled to email as a csv file each morning and it comes over in that file as '2003-08-18 00:00:00'.

Any assistance would be appreciated.

NimrodA

My guess is that date export automatically converts the data format. The only way around I see - of course, maybe someone else could enlighten me - is to create a calculated field which turns the date into a string of the desired format, and using that string instead of the date column. The string will be exported as-is.
Of course, you can always export to xls and have a batch file ready to change xls to csv automatically. That might work.

AussiePete2011

Hi there,

Here's a technote that may explain what is occurring
https://www-304.ibm.com/support/docview.wss?uid=swg21339208

CSV exports raw data no formattting.  If you need to export to a flat file I'd suggest excel rather than csv, otherwise you will need to run a batch script that reads then modifies the data in a specific column.

This is a good site if you want to look at this but you're heading into coding land but then by doing this you can schedule it to be automated.
http://www.java2s.com/Tutorial/Java/0340__Database/ConvertaTimestamptoMonthDayYear.htm

Cheers
Peter B