Entry date and TIME to completion date and TIME | Community
Skip to main content
MeganBa1
MeganBa1
Level 2
March 13, 2024
Question

Entry date and TIME to completion date and TIME

  • March 13, 2024
  • 1 reply
  • 1398 views

I'm trying to build an issues report that shows the entry and completion dates but also the times they were entered or marked closed/resolved.  I am assuming that the system would auto pull in the time associated with an entry and a completion selection.  I am being asked to show how long issues are taking to complete but I can only seem to get the date association -- please note, we don't "log time" in the system, that is why I was trying to pull date/time stamps.  I would like to say that this is the entry date/time stamp and here is the completion date/time stamp and here is the date difference of those two and/or the time difference of those twos.

 

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

KIMBERLYREA
Community Advisor
KIMBERLYREACommunity Advisor
Community Advisor
March 13, 2024

We placed a calculated field on the custom forms for all projects to track this. Here is the calculation:

 

ROUND(WEEKDAYDIFF({entryDate},{actualCompletionDate}),2)

 

MeganBa1
MeganBa1Author
Level 2
March 13, 2024

Does this display on your form or is there a way to hide it? 

 

Thank you!

KIMBERLYREA
Community Advisor
KIMBERLYREACommunity Advisor
Community Advisor
March 13, 2024

We have a custom form of back end reporting data with tons of calculated fields that only our Operations team can see. This field lives on that form for reporting.  We don't have the date field on there. In the reports we show the columns next to each other.  Entry is hard for our group because we bulk upload planned projects once a quarter. But it does show how long for our adhoc projects 

 

Terms & ConditionsAccessibility statement

Loading footer...