Juan
|
Posted: 05/08/2004, 2:42 AM |
|
I'm using CC. I want to be able to show all records base on a null value in the date field.
Is this done with SQL or Events?
Thanks, Juan
|
|
|
peterr
Posts: 5971
|
Posted: 05/08/2004, 12:28 PM |
|
I didn't understand if you want to show all records that contain null dates, or all records if a null date is passed to the form (for example via the search)?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/08/2004, 1:26 PM |
|
Hi Peter,
I found the answer by searching through the archives. I wanted to only to filter by a null date field.
I ended up using date_received IS NULL
The records are now filtering the way I want.
Thanks,
Juan
|
|
|
|