Crystal Reports Is Null function for Date parameter

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

Topic: Is Null function for Date parameter

Author	Message
Report Blues Newbie Joined: 01 Mar 2012 Online Status: Offline Posts: 3	Topic: Is Null function for Date parameter Posted: 01 Mar 2012 at 3:16am
	I am building a query that requires to show employess who signed a tool out on a specific date and never returned it. I am trying to use the Is Null function for the no return date, but get no data. Can someone show me how to do this? When I use DateValue 0000,00,00 it asks for a Date to be inserted... Thanks in advance.
	IP Logged

rkrowland Senior Member Joined: 20 Dec 2011 Location: England Online Status: Offline Posts: 259	Posted: 01 Mar 2012 at 4:25am
	Set the datevalue to #1901-01-01# for no date. Drag the field on to your report > right click it > format field > common > click the x-2 to the right of supress. Enter the following; {table.field} = #1901-01-01# Regards, Ryan.
	IP Logged

Report Blues Newbie Joined: 01 Mar 2012 Online Status: Offline Posts: 3	Posted: 01 Mar 2012 at 4:57am
	Thanks! I did. Here is my statement: {EPD_ACCESS_HISTORY.ENTRY_DATETIME} > DateTime (2012, 01, 01, 01, 04, 01) and {EPD_ACCESS_HISTORY.EXIT_DATETIME}= DateValue (#1901,01 ,01#) and also: {EPD_ACCESS_HISTORY.EXIT_DATETIME}=#1901-01-01# but still get no results (???)
	IP Logged

yggdrasil Senior Member Joined: 19 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 150	Posted: 07 Mar 2012 at 4:32am
	Try CDate(0,0,0) for null date value. Sometimes it works
	IP Logged

Report Blues Newbie Joined: 01 Mar 2012 Online Status: Offline Posts: 3	Posted: 07 Mar 2012 at 4:42am
	Tried that too... it didn't work! Thanks!
	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.