IF({ExpireEnd},IF({ExpireEnd} = TODAY(),INT(0),INT(DATETIME_DIFF( {ExpireEnd}, TODAY(), 'days')) ), "") When “ExpireEnd” field condition is equal today formula returns nothing empty, should return 0 INT(“0”) - with quotes same effect nothing. ...

Hello, who can give an advice how to 22 to 2022 23 to 2023 etc… I guess I can just concat “20” & MyDigits maybe there is possible more elegant solution? UPD: I Found solution with DATETIME_FORMAT(‘01/01/’&MyDigits, ‘YYYY’)

I have the day of payment (PayDay value). and that the next payment will be after 1 month. I need formula which generates date of next payment, In correlation based with today, I have to pay either this month or next (the formula decides) there are s...