Syntax Help - display date of task in Report | Community
Skip to main content
B
BenettaPe
Level 9
August 30, 2022
Question

Syntax Help - display date of task in Report

  • August 30, 2022
  • 1 reply
  • 919 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
August 30, 2022

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

B
BenettaPeAuthor
Level 9
August 30, 2022

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

B
BenettaPeAuthor
Level 9
September 1, 2022

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


Ali,

 

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

Terms & ConditionsAccessibility statement

Loading footer...