Skip to main content

Deadline date formula

  • August 29, 2022
  • 1 reply
  • 11 views
Scott_Gardner1
Forum|alt.badge.img+15

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

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • August 29, 2022

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