Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

INT(0) doesnt works in IF Statement

Topic Labels: Formulas
125 1
cancel
Showing results for 
Search instead for 
Did you mean: 
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

it is looks like bug