General information
Category:
Reports & Report designer
>This should be simple, but I'm not finding it quickly:
>
>I have date field in cursor, sometimes blank. I want to show nothing in the report if blank. I'm using format 99/99/99, but can't seem to blank it out entirely, I get / / trying to use Print When. What's the way to do this without converting to char?
G'day Bruce
You can do an IIF(mydate={}, '', mydate)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only