Skip to content
  • Register

    • Date Question

    Unknown
    Unknown
    in Portal
    Date Question

    Comments

    • Unknown
      Unknown
      edited November 2023

      Hello,

      I’m creating a report with color rules based on dates. And currently I’m trying to make a line turn red if it’s after 3 days of the date it was completed.

      However when I test my rule and I make my completed date the first of this month it failed. Why? Is my logic wrong? Any help would be appreciated.
      Thanks.

    • Unknown
      Unknown
      edited November 2023

      If you want to make the rule evaluate true (row will be red) if the CompletedDate is more than 3 days in the past, this rule should work for you:


      4/1 < 4/22 = true

      A quick note, I believe the Is Before and Is After evaluators in a rule are not working properly currently. You can use a compute date like I did in my example to get around this.

    Sign In or Register to comment.

    Howdy, Stranger!

    It looks like you're new here. If you want to get involved, click one of these buttons!

    Sign In Register

    Quick Links

    Categories