2 Replies Latest reply on Jan 16, 2019 12:53 PM by Ken Flerlage

    IF function with Dates

    Samantha Hsia

      I'm trying to identify accounts where balances were below a certain amount for a period of time with the below expression.

       

      if [ah.AccountBalance] < 10000 and [ah.AsOfDate] > #10/11/2018# and [ah.AsOfDate] < #12/31/2018# then "N" else "Y" end

       

      The formula works fine but I have an account with no balances before Jan 2019 but for some reason the expression below still returns "Y"

       

      Help?