Hi,
I am trying to use the FROMNOW() function to tell me when a transaction has expired within the last month.
Can someone explain why this formula does not return accurate results?
IF(FROMNOW({Expiry date}) <= 1, ‘month’, “Recently Expired”)
It works (i.e. it doesn’t return an error) but it is returning “Recently Expired” for every transaction that has expired, even ones that expired years ago!
Help please! :slightly_smiling_face:
Mark