Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Syntax Help - display date of task in Report

Avatar

Level 2

This is just a task in a project - where I am trying to display in a column in a report - the actual completion date. Clearly i have some syntax off.  Please help.

 

 

displayname=Kickoff Call Target Date Flag
linkedname=direct
namekey=actualCompletionDate
querysort=actualCompletionDate
textmode=true
valueexpression=IF({name}="Kickoff Call Target Date Flag",{actualCompletionDate})
valuefield=actualCompletionDate
valueformat=atDate

4 Replies

Avatar

Community Advisor

I see at least one problem here:

according to documentation you either use valueexpression OR valuefield, but not both as they essentially have the same role

Avatar

Level 2

Thanks - I caught that and removed it - but there is still another syntax error - as the date is not displaying. 

 

valueexpression=IF({name}="Kickoff Call Target Date Flag",{actualCompletionDate},"")
textmode=true
valueformat=atdate
displayname=Kickoff Call Actual Date

Avatar

Level 2

Hi. Are you trying to add this to a task view or report? If so, your syntax above looks pretty good. If you are trying to add this to a project view or report, you will need to utilize collections. You can get more information on referencing collections - here

 

I would try something like this if you are referencing this on a project level.

 

displayname= Kickoff Call Actual Date
listdelimiter=‍
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({name}="Kickoff Call Target Date Flag",{actualCompletionDate},"")
valueformat=atdate

 

Hope this helps!

-Ali

Avatar

Level 2

Ali,

 

Thanks and I am trying to put this in a report.