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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Ali,
Thanks and I am trying to put this in a report.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies