BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - How-To's

How to select / display null / blank dates (write)

At some point you may need to check if a date field is blank. A simple way of doing this is creating a formula to return a true/false value if the field is null/blank.


If date
({date_field}) = cdate(0,0,0)
or
Totext({date_field}) = “” Then True Else False

Tagged , , ,

One thought on “How to select / display null / blank dates (write)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

To change the formatting for multiple text boxes at one time, hold the Shift key while clicking on each text box. Once they’ve all been selected, click on the desired formatting icon(s).

ADVERTISMENT