Format Date in Text Mode

[PujaPa]

Hi Everyone, I tried to search for an answer to this before posting but I was unable to find something that matches. I am modifying a report and I want to display only Year of Project Start Date instead of the entire Project Start Date. So if start date is 2/1/2018, I would like for it to only display 2018. I tried the following based on what I have read so far but was unsuccessful in my attempt. Thank you in advance for your help! displayname= linkedname=direct namekey=actualStartDate querysort=actualStartDate textmode=true valueexpression=YEAR({actualStartDate}) valueformat=atDate Puja Patel

[Doug_Den_Hoed__AtAppStore]

Hi Puja, I suspect your valueformat=atDate is defeating your valueexpression, and instead, suggest you either remove that line, or try valueformat=HTML Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[PujaPa]

You, my friend, are the real MVP. That worked like a charm. Thank you very much for your help! Puja Patel Enabling Solutions