Print Page | Close Window

db2 date 01-01-0001 displayed as 01-01-2001

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4664
Printed Date: 02 May 2025 at 2:18pm


Topic: db2 date 01-01-0001 displayed as 01-01-2001
Posted By: chinatrain99
Subject: db2 date 01-01-0001 displayed as 01-01-2001
Date Posted: 29 Oct 2008 at 1:53pm

Throughout our  tables we populate our invalid date with 01-01-0001. Crystal, is converting this date to 01/01/2001. Seems to be related to patch ID 36375929.

 
Does anybody have an easy work around for this?
 
A link or good instructions on how to fix this?
 
Thanks in advance, Jeff


Replies:
Posted By: rahulwalawalkar
Date Posted: 31 Oct 2008 at 8:41am
Hi,
 
You can check for the field value of date for 01/01/2001 if that is the case then display 01-01-0001 else display the date  from the table field
 
Cheers
Rahul


Print Page | Close Window