Help

Re: Deadline date formula

299 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

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!

1 Reply 1

Hey @Scott_Gardner1!

How about this?

image

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"
            )
        )
    )
)