Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
28 days ago

Formula Date Field

I 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?

 

 

 

  • "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)

  • "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)