Forum Discussion

JamesWarren's avatar
JamesWarren
Qrew Trainee
2 years ago

Using a date in an If statement

I want to write a fairly basic If statement that would look something like this:

If([Resolution Date] > (3+[Initiation Date], "TRUE", "FALSE)

However, I receive the error "Expecting bool but found date".
Are dates able to used in this way? Are there any possible workarounds I could explore?

Thank you!

------------------------------
James Warren
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    If([Resolution Date] > [Initiation Date]+ Days(3), "TRUE", "FALSE")

    but that is the same as this

    If([Resolution Date] > [Initiation Date]+ Days(3), "TRUE")

    which is also the same as this

    [Resolution Date] > [Initiation Date]+ Days(3)


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JamesWarren's avatar
      JamesWarren
      Qrew Trainee
      That works! I appreciate it.

      ------------------------------
      James Warren
      ------------------------------