Crystal Reports XI

I am creating a report that I need to convert to csv format and I am having problems getting the date/time field to come across in csv with quotes. For other fields I have created a formula using totext function, but for the date time field if I add totext it converts it to standard 'mm/dd/yyyy 00:00:00 am'. I need the date format to be 'yyyy-mm-dd 00:00:00'.

Any ideas and suggestion would be greatly appreciated. I need to get this project off my desk and move on to other things :)


Melissa Hietala
UMC, Inc.

Sponsored Link

$200,000 mortgage for $660/mo - 30/15 yr fixed, reduce debt, home equity - Click now for info

[Non-text portions of this message have been removed]