Forum Discussion

dw700d's avatar
dw700d
Post Patron
6 years ago
Solved

countdown days until a project ends

I  would like to create a card that counts down the days remaining until a projects ends.

The project ends  2/16/ 2023, therefore the project ends in 941 days.

As each day goes by I would like the card to countdown the updated count of days, for example tomorrow the card would say

940 the next 939 the next 938 etc... I am aware of the countdown timer but I would rather not use that if I dont have to. I think this is simple but I'm just not sure how to do it. Any one have any suggestions?

 

Regards

Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can use this measure in a card visual to get remaining days.

     

    Countdown = DATEDIFF(TODAY(), DATE(2023,2,16), DAY)

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    You can use this measure in a card visual to get remaining days.

     

    Countdown = DATEDIFF(TODAY(), DATE(2023,2,16), DAY)

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat