Add a Date into report where value is null

[unknown]

First off I work in a jail and I have created a report in
Infomaker 10.5 that list everyone that has been booked in
from 07/01/08 till 06/30/09. But for everyone that has not
yet been released the release date comes up blank. I need to
know if there is a way to have Infomaker add the date
6/30/09 when release date equals Null. If so what would the
statement be and where would I plug that into Infomaker.

[Paul Horan[Sybase]]

Replace the column 'Release_Date' with an expression:

coalesce( release_date, '2009-06-30' )
--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

Post by unknown
First off I work in a jail and I have created a report in
Infomaker 10.5 that list everyone that has been booked in
from 07/01/08 till 06/30/09. But for everyone that has not
yet been released the release date comes up blank. I need to
know if there is a way to have Infomaker add the date
6/30/09 when release date equals Null. If so what would the
statement be and where would I plug that into Infomaker.