Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Syntax Help - display date of task in Report

Avatar

Level 1

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

Level 6

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 1

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