Skip to Content
0
Apr 11, 2016 at 06:50 PM

Replace NULL value with text

162 Views

Hi!

Trying to replace a null value with text. Here's what I have, not working though..

If (isnull({DB.Field.1})

or ({DB.Field.1} ='')) then "VOID"

else

{DB.Field.1}

Maybe it's not working because the {DB.Field.1} is a date/time, i.e.: 4/11/16

?

Thanks!

Rich