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

Tips and Tricks

Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

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

Post Reply

Post New Topic

Author	Message
chinatrain99 Newbie Joined: 29 Oct 2008 Online Status: Offline Posts: 1	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 Logged


rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	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 Logged

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