Skip to main content

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!

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"
            )
        )
    )
)
Terms & ConditionsAccessibility statement