Skip to main content
Level 3
Aug 26, 2026 4:30 PM UTC
Solved

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

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!

seanaberAccepted solution
Level 2
Sep 1, 2026 4:38 PM UTC

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
Aug 26, 2026 7:47 PM UTC

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

Translate
ljorr16Author
Level 3
Aug 26, 2026 8:05 PM UTC

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

Translate
Eric_D_Miller
Level 5
Aug 26, 2026 8:07 PM UTC

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?

Translate
Kurt_Jones
Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Aug 30, 2026 12:01 PM UTC

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:

 

Translate
If my response answered your question, please mark it answered, so others can find the answer
ninoskuflic
Level 6
Sep 1, 2026 5:35 PM UTC

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

Translate
If this solved your issue, please mark it as solved so others can find the solution faster.
seanaberAccepted solution
Level 2
Sep 1, 2026 4:38 PM UTC

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

Translate
ljorr16Author
Level 3
Sep 8, 2026 3:37 PM UTC

Thank you for the excellent explanation!

Translate