This content has been marked as final. Show 2 replies
if [ah.AccountBalance] < 10000 and ([ah.AsOfDate] > #10/11/2018# and [ah.AsOfDate] < #12/31/2018# )then "N" else "Y" end
We'd probably need to see a sample of the data to be sure what's going on. Any chance you could supply a small sample?