
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2022 06:09 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2022 06:17 AM
it is looks like bug
