+12I have a formula date field and this is my formula:
If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],"")
I get an error on the last "" expecting date but found text.
How do I tell it to do nothing if the the formula is not true?
Best answer by MarkShnierYou
"Silence is golden". You don't have to say anything for the alternative, and it will just become null. You also had extra parentheses, but while that doesn't hurt, it just adds clutter.
If (not IsNull([Date ReOpened]) and [ReOpened Reason]="Mishandled",[Date ReOpened])
but if that bothers you, you can also do
If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],null)
+24"Silence is golden". You don't have to say anything for the alternative, and it will just become null. You also had extra parentheses, but while that doesn't hurt, it just adds clutter.
If (not IsNull([Date ReOpened]) and [ReOpened Reason]="Mishandled",[Date ReOpened])
but if that bothers you, you can also do
If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],null)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
