what I have in there now is

 

if isnull ({Table.field})

then

"TBD"

else

totext ({Table.field})

 

With this formula I am unable to then format the the way the date is displayed? 

 

im sure there is a different formula to accomplish this, but I do not know what operators to use. 

 

e.g. totext(table.date,"M/d/yy")

 

from crystal help here are the options

Character	Comments
d	day of month without leading zero for single digits
dd	day of month with leading zero for single digits.
ddd	day of week as a three letter abbreviation
dddd	full name of day of week
M	month without leading zero for single digit
MM	month with leading zero for single digit
MMM	month as three letter abbreviation.
MMMM	full name of month
yy	last two digits of year
yyyy	full four digits of year
h	hours without leading zeros for single digits (12 hour)
hh	hours without leading zeros for single digits (12 hour).
H	hours without leading zeros for single digits (24 hour)
HH	hours with leading zeros for single digits (24 hour)
m	minutes without leading zeros for single digits
mm	minutes with leading zeros for single digits
s	seconds without leading zeros for single digits
ss	seconds with leading zeros for single digits
t, tt	single character or multiple character a.m./p.m. string

 

 

 

that did it