Pulling most recent project update into a report

[KarenNe1]

I may have asked this before, but I can't find my original post.

I have a task report and I added a column to pull the project update notes.  I thought that it would pull the most recent update note, but it's not.  It's pulling the first note.  Do you know how I can have the most recent update not show in my report?

This is the text code for the updates note column.  Do I need to modify this code or is there something different that I have to do or it not possible to do what I want?

displayname=
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=TDM Update Notes
querysort=DE:project:TDM Update Notes
valuefield=project:TDM Update Notes
valueformat=customDataLabelsAsString

[NicholeVargas · Accepted solution]

@KarenNe1 You can use the field for Last Note - Note Text to pull in the most recent update on the project. Your text mode would look like this:

displayname=Last Update on Project
textmode=true
valuefield=project:lastNote:noteText
valueformat=HTML