Home

Product Manager's Corner: Sage Employee Self Service is getting a new look and going mobile!

Training Corner:
Everyone’s talking about Virtual Classroom Training!

Product Focus Corner:
Help is Always Available

Be The First:
To Experience the New Sage HRMS 2012!

How To:
Set up Secondary Job for Employees

Audit Reporting:
"Who Dun It?"

Updates:
Quarterly Tax Schedule

Crystal Reports v10:
Exporting Null Date Values from Crystal to Microsoft Excel

Sage Abra Payroll

Exporting Null Date Values from Crystal Reports v10 to Microsoft Excel

In Crystal v10, when exporting to Excel a date field where some records have null date values, the nulls display in Excel as ########. When widening the field in Excel, the date displays as 1/0/1900. This is because the null date is transferred as zero and Excel displays a zero date as 1/0/1900.

How do you get the date to display as blank in Excel?

Solution:
In your report, create a formula called DateForm to use in place of the actual date field:

@DateForm will be the formula field you then add to the Crystal Report.

If IsNull({DateField}) Then "" Else ToText({DateField},'MM/dd/yyyy')

© 2011 Sage Software, Inc. All rights reserved. Sage, the Sage logo, and the Sage products and services mentioned herein are registered trademarks or trademarks of Sage, Inc. All other trademarks are the property of their respective owners.