Crystal will interpret blank date values to some random date in the year 1800's.
You can write the following code in the
SUPPRESS button of the date field
year({po_master.po_date})<1900
>Hello,
>
>I have a datetime field in a report. If the date is empty, I want to print "____/____/_____". If the date is filled in, I want to print the date.
>
>How do I test to see if the datetime field is empty and write the formula in Crystal Report version 9 to either display the datetime in a string or the blank line in a string?
>
>Thanks,
>
>TFISHER
Sanjay Dhiraj Patel
MCSE, MCDBA
Net2Biz (Thailand)