Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: db2 date 01-01-0001 displayed as 01-01-2001 Post Reply Post New Topic
Author Message
chinatrain99
Newbie
Newbie


Joined: 29 Oct 2008
Online Status: Offline
Posts: 1
Quote chinatrain99 Replybullet Topic: db2 date 01-01-0001 displayed as 01-01-2001
    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


Edited by chinatrain99 - 29 Oct 2008 at 1:54pm
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.