Hi @Mark_Jeavons - the FROMNOW formula doesn’t work in the way you have tried above. By trying out FROMNOW on its own you can see the results it gives:
It is giving a string as a result, not an integer. Your formula reads:
If fromnow is less than 1, then display “month”, otherwise “recently expired”
As the string value returned by FROMNOW is never less than 1, the IF always returns the 2nd value.
Note that FROMNOW just takes a date argument, it doesn’t take a time unit argument (days, months) like other date based functions.
To get what you are after try using DATETIME_DIFF
DATETIME_DIFF(TODAY(), Date, 'days')
(I’ve used ‘days’, but you could also use ‘month’)
Then your formula field could be:
IF(DATETIME_DIFF < 28, 'Recently Expired')