Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Empty fields Post Reply Post New Topic
Author Message
mparish
Newbie
Newbie


Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mparish Replybullet Topic: Empty fields
     Posted: 05 Nov 2008 at 3:32pm
How do you write a formula to pull date/time fields that are empty or have no data? I have tried "  " but that doesn't work.
 
I am trying to pull accounts that are Inactive yet do not have a stop date.
 
Thanks!!
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: 06 Nov 2008 at 2:53am
Hi
 
Try using IsNull({Table.FiledName})
 
cheers
Rahul
IP IP Logged
mparish
Newbie
Newbie


Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mparish Replybullet Posted: 06 Nov 2008 at 5:25am
{Taxpayers.Status}='I' AND {TaxpayersLocationsTaxes.StopDate}isnull
 
This didn't work. Could it be because the stopdate is a date/time field and not a string? Other suggestions? 
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: 06 Nov 2008 at 6:30am
Nope
 
you have to use
isnull ({TaxpayersLocationsTaxes.StopDate})
 
cheers
Rahul
IP 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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.