I am trying to do this but it's not working: The business wants to see how often there is between the due date of the previous task versus the current task, and if that's less than 2 days. So I am trying to do a datediff between the predecessor planned completion date and the current task, but its coming up blank. I am sure I have the formatting messed up but I am still learning TEXTMODE.
displayname=Task Planned Completion Date Vs Predecessor Planned Completion Date
linkedname=direct
querysort=plannedCompletionDate
textmode=true
valueexpression=ROUND(DATEDIFF(({predecessor}.{plannedCompletionDate}),{plannedCompletionDate}),2)
valueformat=HTML