Hello!
I'm running Crystal Enterprise on a Windows 2000 server.
I also have Crystal Report installed on the same server.
My problem is that i get wrong date format when exporting a report to excel or pdf, but right format when I save it as crystal format.
And also when running the report thru Crystal Report I get it right.
I want the result to look like this: 'YYYY-MM-DD HH24:mm:ss' (2004-03-09 15:25:20)
but when exporting I get it like this: 3-9-2004 3:25:25 PM
I have looked at the Regional Settings on the server and they seems to be ok.
If I format the field in CR and not use the system default settings I get the right format as well, but we have just upgraded from an InfoServer to Crystal Enterprise, and we have about 400 reports and I don´t want to manually change all of them.
Does anyone know how to fix this problem.
Thanks
Goran
I'm running Crystal Enterprise on a Windows 2000 server.
I also have Crystal Report installed on the same server.
My problem is that i get wrong date format when exporting a report to excel or pdf, but right format when I save it as crystal format.
And also when running the report thru Crystal Report I get it right.
I want the result to look like this: 'YYYY-MM-DD HH24:mm:ss' (2004-03-09 15:25:20)
but when exporting I get it like this: 3-9-2004 3:25:25 PM
I have looked at the Regional Settings on the server and they seems to be ok.
If I format the field in CR and not use the system default settings I get the right format as well, but we have just upgraded from an InfoServer to Crystal Enterprise, and we have about 400 reports and I don´t want to manually change all of them.
Does anyone know how to fix this problem.
Thanks
Goran