Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

INT(0) doesnt works in IF Statement

Topic Labels: Formulas
793 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