Crystal Reports Searching on blank data field

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Searching on blank data field

Post Reply

Post New Topic

Author	Message
ian jordan Newbie Joined: 16 Feb 2011 Online Status: Offline Posts: 2	Topic: Searching on blank data field Posted: 17 Feb 2011 at 12:00am
	I'm trying to run a report on all pending cases in a data base. A case is deemed to be pending if no date is present but i cant seem to work out how to search against a date data field with no date entered. Any help would be appreciated.
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 17 Feb 2011 at 2:16am
	what about isnull() or len(table.datefield)<1?
	\|< /\ '][' ( )
	IP Logged

ian jordan Newbie Joined: 16 Feb 2011 Online Status: Offline Posts: 2	Posted: 17 Feb 2011 at 4:13am
	ta for that but still cant get it to work, just keep getting "the remaining text does not appear to be part of the formula" error message. I must be missing something.
	IP Logged

FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 17 Feb 2011 at 7:24am
	what is your exact formula? May be missing a ) or something along those lines.
	\|< /\ '][' ( )
	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