I detest "blanks" in any report.  Even if there is no data then I create an "IF" statement to fill something in. 

That being said....

I have in my report a date/time field.  If it is blank I want it to input some text.  so my formula reads

If
isnull({table.datefield})
then
"See Comments"
Else
totext({table.datefield})

Where I run into an issue is getting the date formatted in such a way as we are used to seeing it.  We prefer to use the format

DD-MMM-YY  (i.e. 18-FEB-14)

How can I accomplish this formatting with the above formula in place or is there a better way to handle the blank date information. 

Many Many thanks