Display Timesheet approval date

[DeepaMa1]

Hello All,

I have created an hour report to display all the hours logged in by users for projects. I am able to display timesheet approver name and timesheet status. How can I display timesheet approval date in Workfront report?

Thank you in advance!

Deepa Mahishi

[monicacardoso · Accepted solution]

Hi @DeepaMa1, 

Thank you for your question! In Workfront, the timesheet approval date is not directly available as a standard field in reports. You can look at the lastUpdateDate field instead and include an expression to ensure that it was last edited by the approver and that the timesheet is currently closed. 

Navigate to your existing report and add a new column; then switch to text mode and paste the following: 

displayname=Timesheet Approval Date
linkedname=direct
namekey=timesheet:lastUpdateDate
querysort=timesheet:lastUpdateDate
valueexpression=IF({timesheet}.{lastUpdatedByID}={timesheet}.{approverID}&&{timesheet}.{status}="C"&&!ISBLANK({timesheet}.{lastUpdatedByID}),{timesheet}.{lastUpdateDate},"")
valueformat=longAtDate

- Monica 

[DeepaMa1]

Thank you @monicacardoso Thank you for providing the code and it was very helpful.