I am trying to use an if statement to say "If (a field = "NQ") then return a different date field else leave blank. I wrote the formula like this:

If({ROTPersonnelStatusTableB.Type}="NQ") then {ROTPersonnelStatusTableB.Expiration Date} else " "

but I am getting an error saying that I need to have a date in the "else" section. Does anyone know a way around this?


Edited by knaylor - 11 Aug 2010 at 6:26am