Help

INT(0) doesnt works in IF Statement

Topic Labels: Formulas
703 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasilii_Lysenko
5 - Automation Enthusiast
5 - Automation Enthusiast
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.
when I put in formula just “0” - without INT() - its ok

Also work fine when I use any number other than zero

1 Reply 1
Vasilii_Lysenko
5 - Automation Enthusiast
5 - Automation Enthusiast

it is looks like bug