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"

            )

        )

    )

)

Reply


Terms & Conditions