I am creating a report to show if a purchased part has been received. I would like to have the letter "TBD" to show if the item hasnt been recieved other wise show the date it was received.
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.