Crystal Reports Empty date field

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Empty date field

Author	Message
kader Newbie Joined: 11 Jun 2012 Location: Qatar Online Status: Offline Posts: 18	Topic: Empty date field Posted: 18 Aug 2013 at 4:32am
	There is a date field some records are empty ( N date) but while printing crystal it is print as 01/01/53 which I wanted to eliminate and show nothing. Please can any one tell me how to do this ?? Kader
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 19 Aug 2013 at 1:29am
	Hi Create following formula and insert formula inplace of your date field : If isnull(date_field) or datefield = date(1953,01,01) Then " " Else ToText({DateField}."MM/dd/yyyy")
	Thanks, Sastry
	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.