Unanswered

Check how long since status closed

(0) Share

Report

Posted on by PowerApps11

521

Is there a possible to know when status closed by days? for example i have Created Date Due Date Date completed all are Date and Time fields so when status a choice field changed to closed i would like to count the days and show me on a label how many days it took since closed by comparing these dates Created DateDue DateDate completed so i will know if its closed more than what original due date.
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You could use the DateDiff() function. As per my example:
--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
PowerApps11 521 on at

Like
a
(0)

Report
Copy link

Link copied!

@365-Assist
Thanks for your quick response, but I need to add the due date also, so that I know if it's not Closed on the due date,
for example, the created is 1/1/2022 and Due date is 1/15/2022 now If I close the status on 1/20/2022 so I know how many days is past the due date

Was this reply helpful? Yes No
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Could you not do the same approach I recommended but also add the Due date as another date and another calculated label?

Was this reply helpful? Yes No