Crystal XI, exporting null date fields to EXCEL without the 01/00/1900

Posted on 2014-02-13
Medium Priority
Last Modified: 2014-04-02
I am trying to export from Crystal Xi a date field, based on a grouping, and the most current sequence of dates on my data, In order to get the most current date I have found setting up the field as a date and do a summary on Maximum to the group and just exporting the date field is giving me the right information, BUT...  when I export to Excel if the field is blank the result in Excel is 01/00/1900.  If I change the date to a text field with the else "" I do not have this problem, BUT the most current date does not appear.   Please advise.


{EMSI_EMPLOYEE_SKILLS.USER_DATE_1} <> Date(0,0,0)) then
Question by:Grapelady
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 101

Expert Comment

ID: 39858075
Date(0,0,0) is 1 Jan 1900

Try it this way as strings

{EMSI_EMPLOYEE_SKILLS.USER_DATE_1} <> Date(0,0,0)) then

Open in new window


Author Comment

ID: 39893613
I have attached a document showing what I am trying to accomplish. The suggestion you gave above I am receiving an error, see attached document.

Accepted Solution

Grapelady earned 0 total points
ID: 39893655
I think I just found a solution, if you place a suppression on the field formula for the date and if the date value is 0 then it will suppress those records that do not have a date:  

Date field = Date(0,0,0) it will not export 01/00/1900 to Excel if the value is zero.

I don't know if anyone wants to confirm this or not, but it is working.

Author Comment

ID: 39968339
Please close the question.

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question