Skip to main content
Question

Using a date in an If statement

  • December 1, 2022
  • 0 replies
  • 271 views
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement