5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Nov 28, 2018
‎Nov 29, 2022

User Statistics

  • 4 Posts
  • 0 Solutions
  • 4 Kudos given
  • 1 Kudos received

User Activity

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...