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!