Skip to main content
Level 3
August 26, 2026
Solved

Calculate datediff between issue entry date and the date it was converted to aporject.

  • August 26, 2026
  • 8 replies
  • 89 views

I’m trying to create a project level report that captures issue “wait time” -- the time between when an issue was entered (convertedOpTaskEntryDate) and the date the issue was converted into a project. I cannot seem to find a way to do this. I can create a new field to time stamp the conversion date, but how would I do that? Thanks!

Best answer by seanaber

Eric's suggestion above is the right shape, and the conflicting information you ran into is worth clearing up, because the other route fails in a quiet way.

The entry date on the issue and convertedOpTaskEntryDate on the project are the same timestamp. convertedOpTaskEntryDate is not the moment of conversion, despite the name. It is a copy of the source issue's own entry date, stamped onto the project when the conversion happens. Pair those two and you get zero, every time, with no error to tell you why.

I checked this against a tenant rather than going from the field name: on every converted project sampled, the project's convertedOpTaskEntryDate matched the source issue's entryDate to the millisecond, while the project's own entryDate sat days or weeks later. On unconverted projects both fields come back null, so it is not a general-purpose date being read wrong.

The useful part is that the pair you want sits entirely on the project, so there is no join and no cross-object reference:

DATEDIFF({entryDate},{convertedOpTaskEntryDate})

entryDate on a converted project is the project row's own creation, and on a converted project that creation is the conversion. That is also why Eric's version works, since project entry date really is the conversion moment. One caveat on that half: I confirmed the copied-date behavior directly, but I inferred the "project entry date equals the conversion moment" part from it being the row's creation timestamp, rather than timestamping a live conversion, so sanity-check it against one project whose history you already know.

Also worth knowing if you ever want to report this from the issue side: the issue carries no matching back-reference. The conversion linkage is recorded on the project only, so the report has to start from the project.

This one is in the open-sourced Workfront knowledge base I keep, along with the rest of the field-semantics traps: github.com/Thousand-Cuts/wf-toolkit

8 replies

Eric_D_Miller
Level 5
August 26, 2026

Could you weigh the entry date of the original request/issue against the entry date of the attached project?

ljorr16Author
Level 3
August 26, 2026

That’s what I was thinking about, but I’ve seen conflicting information about what the project “entry date” represents. 

Eric_D_Miller
Level 5
August 26, 2026

The entry date on the project represents the exact time the project was entered into the system. Would this reflect the issue/request conversation date?

Kurt_Jones
Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
August 30, 2026

ljorr16 -

Use can created a calculated field.  Use the entryDate from the issue and the convertedOpTaskEntryDate of project (that is date when issue was converted to a project).  An example below:

 

If my response answered your question, please mark it answered, so others can find the answer
ninoskuflic
Level 6
September 1, 2026

This! I always went with this approach when trying to achieve exactly what you want and I would recommend this as a good approach. 🙂

If this solved your issue, please mark it as solved so others can find the solution faster.
seanaberAccepted solution
Level 2
September 1, 2026

Eric's suggestion above is the right shape, and the conflicting information you ran into is worth clearing up, because the other route fails in a quiet way.

The entry date on the issue and convertedOpTaskEntryDate on the project are the same timestamp. convertedOpTaskEntryDate is not the moment of conversion, despite the name. It is a copy of the source issue's own entry date, stamped onto the project when the conversion happens. Pair those two and you get zero, every time, with no error to tell you why.

I checked this against a tenant rather than going from the field name: on every converted project sampled, the project's convertedOpTaskEntryDate matched the source issue's entryDate to the millisecond, while the project's own entryDate sat days or weeks later. On unconverted projects both fields come back null, so it is not a general-purpose date being read wrong.

The useful part is that the pair you want sits entirely on the project, so there is no join and no cross-object reference:

DATEDIFF({entryDate},{convertedOpTaskEntryDate})

entryDate on a converted project is the project row's own creation, and on a converted project that creation is the conversion. That is also why Eric's version works, since project entry date really is the conversion moment. One caveat on that half: I confirmed the copied-date behavior directly, but I inferred the "project entry date equals the conversion moment" part from it being the row's creation timestamp, rather than timestamping a live conversion, so sanity-check it against one project whose history you already know.

Also worth knowing if you ever want to report this from the issue side: the issue carries no matching back-reference. The conversion linkage is recorded on the project only, so the report has to start from the project.

This one is in the open-sourced Workfront knowledge base I keep, along with the rest of the field-semantics traps: github.com/Thousand-Cuts/wf-toolkit

ljorr16Author
Level 3
September 8, 2026

Thank you for the excellent explanation!