Forum Discussion

knishal's avatar
knishal
Regular Visitor
4 years ago
Solved

Show overdue task

I currently have this formula which shows the amout of days its due by: 

 

OverDueTask = DATEDIFF(TODAY(), Tasks[DueDate], DAY )
 
How can I modify it to show only OVERDUE Task and the day count?

 

  • PabloDeheza's avatar
    PabloDeheza
    4 years ago

    Hi there!
    You can use a IF statement, so:

    VAR _Days =

    DATEDIFF(TODAY(), Tasks[DueDate], DAY ) 

    RETURN

    IF(

    _Days >= 0,

    BLANK(),

    _Days

    )

     

    Let me know if that helps!

2 Replies

  • PabloDeheza's avatar
    PabloDeheza
    Solution Sage
    4 years ago

    Hi there!
    You can use a IF statement, so:

    VAR _Days =

    DATEDIFF(TODAY(), Tasks[DueDate], DAY ) 

    RETURN

    IF(

    _Days >= 0,

    BLANK(),

    _Days

    )

     

    Let me know if that helps!