I have tried various iterations and have not been able to find a
solution.

We use a program to insert bookmarks into word from an SQL server. One
of the fields is a date and it is either a date or an empty field. I
am trying to get the date to display if there is one and an "N/A" if
there is not.

I have tried the following

{ =if imported_date 0 imported_date N/A}

I've tried it with { } around the bookmarks and " " and all sorts of
switches. I even tried converting the date to a different format
yyyyMMdd and comparing it.

Please somebody help.

Thanks,

Ryan