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.
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.
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