I am using a simple formula:
IF(TDay > TODAY(), 1, 0)
It works fine in a table where TDay is a field containing Date values.
However when I use the formula in another table where TDay is a field containing Date values that are pulled from another table via a lookup then the formula does not work (it either provides all 0s or all 1s and does not perform the evaluation function).
Any thoughts on what I’m doing wrong? Thanks in advance.