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
Aug 29, 2022 12:18 PM
Hello-
Any help on not showing negative days here, just show if the number is negative, it says zero?
IF({DESIGN DUE DATE}=“”,‘’,
CONCATENATE(DATETIME_DIFF({DESIGN DUE DATE}, {TODAY’S DATE},‘days’), ’ Days '))
Thank you!
Aug 29, 2022 01:39 PM
Hey @Scott_Gardner1!
How about this?
IF(
{DESIGN DUE DATE},
IF(
DATETIME_DIFF(
{DESIGN DUE DATE},
TODAY(),
'days'
) = 1,
DATETIME_DIFF(
{DESIGN DUE DATE},
TODAY(),
'days'
) & " Day",
IF(
DATETIME_DIFF(
{DESIGN DUE DATE},
TODAY(),
'days'
) = 0,
"Today",
IF(
DATETIME_DIFF(
{DESIGN DUE DATE},
TODAY(),
'days'
) > 1,
DATETIME_DIFF(
{DESIGN DUE DATE},
TODAY(),
'days'
) & " Days"
)
)
)
)