Workfront Reporting: Days Until Due

[CindyTr1]

I'm looking to add a column to a task report that calculates the number of days until the planned completion date. I've been playing around with various formulas but haven't quite figured it out.

[skyehansen]

can you share what you've been playing with? There are a number of different ways to achieve what you're looking for, as far as I know.

You should have picked one of the formulas from the calculated data expressions help article:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/...

You could have gone with DATEDIFF, WEEKDAYDIFF, or WORKMINUTESDIFF, for example.

You should have picked one of the wildcard variables from the wildcards help article:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/report-elements/underst...

(either $$TODAY or $$NOW)

You should know to express your field as camelCase and in curly braces.

Assuming a standard scenario, this might boil down to something like WEEKDAYDIFF($$TODAY,{plannedCompletionDate}) -- but like I said... there are lots of other options that really depend on what you're looking for.

[CindyTr1]

Hi! Thank you for your response. I tried using what you shared... but the column is still showing up empty without any data. I would imagine this is a standard scenario - I'm just looking for the number of days until planned completion date (weekends included). I have the planned completion date column renamed to "Due On" but I don't believe that would impact the formula?

[skyehansen]

have you considered putting in a valueformat line? e.g. valueformat=HTML is a popular line to add.

[CindyTr1]

It's still not returning anything in the column for me... Do I have all the syntax correct?

[skyehansen]

I don't really like looking at screenshots. Can you copy/paste your code here, and I'll copy and paste it into my report to see if I get a result?

[CindyTr1]

displayname=Days Until Due
textmode=true
valuefield=DATEDIFF($$TODAY,{plannedCompletionDate})
valueformat=HTML

[skyehansen]

instead of valuefield, you should be going with valueexpression -- please read up on the difference here:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/text-mode-syn...

[CindyTr1]

That worked - thank you