Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2008

    Unanswered: Crystal Report XI - export to Excel with date 1/0/1900

    The following pertains to crystal reports 11. I apologize if I've placed this in the wrong forum, or if this question has been answered before. I had no luck finding any answers and have been stuck on this problem for a few days. I hope one of the smart people in this forum might have an idea for me. My report pull from a date field in the database which can be null. The dates appear as expected in the Crystal Report Viewer and PDF, but when I go to export them to Excel the date value for null comes out as 0 which is of course translated to 1/0/1900. Is there a way to make the null date to come out as a blank? I have not been able to figure out a solution to work around this problem. Please help, any help is appreciated. Thanks
    Last edited by saigon1; 09-08-08 at 12:04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts